+ Reply to Thread
Results 1 to 2 of 2

Creating chart based on a filtered results

  1. #1
    Registered User
    Join Date
    04-19-2011
    Location
    Sofia
    MS-Off Ver
    Excel 2010
    Posts
    7

    Creating chart based on a filtered results

    Hi all,

    So generally my question is how I can create a chart based on already filtered information (I mean I already used a filter/s on the rows), so when I take the filter out the chart stays the same as when I was filtered it.

    For example:

    1) When I make a chart based on filter like: (REFER TO: Capture1.JPG)
    2) When I take the filter out I want the chart to be the same as before (like in Capture1.JPG), instead of (REFER TO Capture2).

    MANY THANKS FOR ANY HELP ON THE ISSUE.
    Attached Images Attached Images

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Creating chart based on a filtered results

    Ensure "Plot visible cells only" is checked under Tools>Options>Chart.
    andy pope charts
    http://www.andypope.info/charts.htm
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ 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