How to hide data in a graph?

Vesala · Newbie Joined: 11 Dec 2008 Posts: 2

Hi,

My problem is that I can't hide data in a graph (x,y -diagram).

I have data in many columns and that data is represented in a graph. I have made macros that hide a specific column. The problem is that when I hide a column, the data is not hidden in the graph. Why isn't it and how can I do this?

I have search all the options and forum posts but I can't understand why the data is not hidden.

Thanks

RickRandom · Super User Joined: 27 Jan 2006 Posts: 1082 Location: UK

The chart is simply displaying the numbers in the relevant cells, whether or not they are visible or hidden cells.

I suggest (provided the amount of data isn't huge) that you have "helper" columns that use an IF( ) function that looks at a cell that your Macro sets, something like:

=IF($E$1="Show";A1;0)

where your original data is in A1 and so on, and the chart refers to the cells with the IF( ) functions rather than the original data.

Sorry if this is unclear...

Vesala · Newbie Joined: 11 Dec 2008 Posts: 2

No, on the contrary, it's quite clear.

Thanks for the idea! I will try that.