Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Creating charts from filtered data

  1. #1
    Join Date
    20th July 2006
    Location
    Dorset
    Posts
    18

    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,

    Martin

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,697

    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 HELP
    Replies: 4
    Last Post: June 28th, 2006, 18:05
  2. Creating Custom Data Points in Charts
    By Jong in forum EXCEL HELP
    Replies: 12
    Last Post: June 28th, 2004, 21:24
  3. Replies: 3
    Last Post: February 25th, 2004, 06:42
  4. Charts: Creating Charts from Lagre Data file
    By mroctobar in forum EXCEL HELP
    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

Bookmarks

Posting Permissions

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