Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Chart Legend Items: hide/show
How do I hide/show a series on a chart legend (scatter plot.)
I tried a null string (""), but the trace still shows. I also tried #N/A. But it then shows "#N/A"; the same with function: NA(). What I am trying to do is to have a control button to show or hide a series from the chart. I can set all the series values to #N/A which hides it, but I am having trouble trying to hide the legend for the series. I also tried an "if" function in the chart-series dialog, but It evidently will only accept a cell pointer. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart items moving around | Excel Discussion (Misc queries) | |||
Activating a Chart object | Charts and Charting in Excel | |||
Chart Legend Entries | Excel Discussion (Misc queries) | |||
How to hide a dummy series in a chart legend? | New Users to Excel | |||
Stack Chart Legend Display | Charts and Charting in Excel |