Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
show/hide multiple series using named ranges
I'm trying to create a dynamic chart using named ranges that will not only
expand or collapse based on the data size, but will also dynamically show varying number of series. I've seen some posts that appear to address this, but I can't quite make it happen. My data is structured similar to this: Date (A1) Series1 (B1) Series2 (C1) 6/15/2007 1000 1500 6/16/2007 1200 1550 6/17/2007 1150 1400 Not only could I have varying number of days starting in cell A2 going down, but I could also have varying number of series. Today I may have two series to chart, but next time, I could have 5 series. If I initially create my chart adding many series--say like 20 (more than I'd ever need), and then only have data for a few series, the chart will only plot a couple of lines like I want, but the legend will show placeholders for all 20 series. Is there any way I can create a dynamic chart that will allow me to only show the number of series with data (and only show these in the legend)? Lastly, I want to avoid using VBA since this is going to be a downloadable report from the web. Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
show/hide multiple series using named ranges
The only way that I can think is if you can force the value #N/A or blanks
into the values in the source. If that is not possible, how ill you recognise that the series is empty? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "goofy11" wrote in message ... I'm trying to create a dynamic chart using named ranges that will not only expand or collapse based on the data size, but will also dynamically show varying number of series. I've seen some posts that appear to address this, but I can't quite make it happen. My data is structured similar to this: Date (A1) Series1 (B1) Series2 (C1) 6/15/2007 1000 1500 6/16/2007 1200 1550 6/17/2007 1150 1400 Not only could I have varying number of days starting in cell A2 going down, but I could also have varying number of series. Today I may have two series to chart, but next time, I could have 5 series. If I initially create my chart adding many series--say like 20 (more than I'd ever need), and then only have data for a few series, the chart will only plot a couple of lines like I want, but the legend will show placeholders for all 20 series. Is there any way I can create a dynamic chart that will allow me to only show the number of series with data (and only show these in the legend)? Lastly, I want to avoid using VBA since this is going to be a downloadable report from the web. Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide or show a series with a button | Charts and Charting in Excel | |||
Allow show/hide option for Excel graph series | Charts and Charting in Excel | |||
Using a series of named ranges in SUMPRODUCT | Excel Worksheet Functions | |||
Multiple Named Ranges in the Same Column | Excel Worksheet Functions | |||
Named Ranges don't show up in drop-down list | Excel Discussion (Misc queries) |