• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

hide a series in a chart

N

nitzan

New Member
hello,

I have a chart with 7 categories (line's data) and 3 series (column's data).
It's like every category in the graph has 3 types of data (actual, budget, forcast for example).
I have a list-box where you can choose the type of series/data that you want to display (i can have actual2012+actual2013+budget2013 or actual2013+forcast2013+budget2013) and the graph changes as chosen.

The problem -
When I want to display only 2 series like actual2013+forcast2013 only, I can't hide the 3rd series and it stays there as it all with 0 values. The 2 first series are not in the middle of the scale and the legend has the the 3rd series colored square with no title of course.
Hiding the entire column doesn't work as hiding a line (then the category is hidden).

how can I fix this for dynamically use?
 
The series that you don't want to show, can you make the formulas evaluate to #N/A? Something like
=IF(PlotIt=True,DataPoint,NA())

The legend is a little trickier to do that way though, as it can't be hidden... :(
Do any of Chandoo's dahsboards look similar to what you are trying to do?
http://chandoo.org/wp/tag/dashboards/
 
Hi Hui,
yes, I've already answered - If I make those cells to #N/A I get those #N/A in the chart.

Have another idea?
 
That doesn't sound right. XL won't plot NA() in a chart.

Most people take the time to moch up a sample of their problem and post that sample file. A chart is only a series of figures and a title so putting dummy data in a workbook and firing that into the forum is not a biggie for most. After all this process takes about 10 minutes to do.

Can we see something by way of a sample workbook? Otherwise people can only guess. Seeing your problem solves your issues almost instantly.

Take care

Smallman
 
You don't make them N/A# you make them =na()

Refer to Luke's comment above
 
Hi Nitzan,

I have created a sample workbook for your query. check and see is this of any help.
 

Attachments

  • CHART.xlsx
    15.4 KB · Views: 5
You must log in or register to reply here.
Back
Top