+ Reply to Thread
Results 1 to 2 of 2

Hide Blank series in a chart

Hybrid View

tmaskhulia Hide Blank series in a chart 12-06-2012, 03:26 PM
lmp Re: Hide Blank series in a... 12-07-2012, 04:52 AM
  1. #1
    Registered User
    Join Date
    08-23-2012
    Location
    San Francisco
    MS-Off Ver
    Excel 2010
    Posts
    1

    Hide Blank series in a chart

    Hello,
    I need your help, I'm making drop-down lists on charts, so when I choose ALL in the list the chart shows information about 4 regions and the series' names are: Americas, EMEA,....
    When I want to choose only one region in a list for instance Americas I could manage to hide the name of series but the colors and lines for it still remains, So my question is do you know any way to completely hide blank series and if I choose one region only I want to hide other region colors and series, so I could have only Americas.

    Thank you
    Untitled.jpg

  2. #2
    Forum Contributor
    Join Date
    11-07-2012
    Location
    .
    MS-Off Ver
    2003 - 2013 for Windows
    Posts
    121

    Re: Hide Blank series in a chart

    Hello,

    you'll need VBA if you want to plot a varying number of series in a chart. See Jon Peltier's article here: http://peltiertech.com/WordPress/dyn...t-source-data/
    regards, LMP

+ 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