Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 2 of 2

Thread: Creating charts from filtered data

  1. #1
    Join Date
    20th July 2006

    Creating charts from filtered data

    After the great help I received earlier in the week, I thought I’d have another go!

    I am generating a database via a userform. Currently when a specific company wants to have a look at the data pertinent to them I have a routine to select the name using the autofilter via a button on the sheet. The data generated by the autofilter is displayed as a sum (using the subtotal(3, Range:Range) command and then a pie chart is generated via another routine that I recorded.

    My question is, how can I make this neater? My ideal would be to have a ‘proper’ search routine to search by company and date and then have this displayed as a chart on a new sheet. What I am doing currently is okay, but I’m struggling to make it more user friendly and efficient!

    I've had a good search through the forum and can't seem to find anything along the lines of what I'm after.

    Many thanks,


    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    24th January 2003

    Re: Creating charts from filtered data

    When the data is filtered down any chart referencing the range should only plot the visible cells. Ensure "Plot visible cells only" is checked under Tools>Options>Chart.

    See also: Excel Charts compliments of Andy Pope, for more inspiration and ideas

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. creating charts with formula not data
    By sam1000 in forum Excel General
    Replies: 4
    Last Post: June 28th, 2006, 18:05
  2. Creating Custom Data Points in Charts
    By Jong in forum Excel General
    Replies: 12
    Last Post: June 28th, 2004, 21:24
  3. Replies: 3
    Last Post: February 25th, 2004, 07:42
  4. Charts: Creating Charts from Lagre Data file
    By mroctobar in forum Excel General
    Replies: 4
    Last Post: June 7th, 2003, 04:21
  5. Charts: Help creating multiple charts from data
    By mroctobar in forum Excel and/or Access Help
    Replies: 5
    Last Post: June 7th, 2003, 01:44


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts