+ Reply to Thread
Results 1 to 3 of 3

How do i create a chart that updates for autofiltered selection

  1. #1
    Registered User
    Join Date
    06-20-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2010
    Posts
    2

    How do i create a chart that updates for autofiltered selection

    Hi

    I have a large set of data that i would like the individual user to be able to chart based on their selection from an autofilter in the data, i have attached an example of the data and the type of chart i would like, can anyone help me to do this?

    ThanksExample.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    04-30-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    547

    Re: How do i create a chart that updates for autofiltered selection

    Include all the data rows in the chart, then use the autofilter to hide/show selected rows only. The chart will only plot the visible rows.
    Like a post? Click the star below it!

  3. #3
    Registered User
    Join Date
    06-20-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: How do i create a chart that updates for autofiltered selection

    Ha ha, so simple! Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1