Dissapearing Chart Data

[vonryan]

Hi All,

I have a spreadsheet that shows predicted and actual incoming money. On this worksheet I have a graph that show the above

I have a VBA button that hides the rows of the data from which the graph is derived.

If I hide the data the graph changes. ie the hidden data is no longer available on the graph.

This is not what I want. I just want to want to hide the data in the list until it is needed to be viewed.

Please help.

Vonryan

[#2 · Accepted solution]

@vonryan 

Select the chart

Select the Chart Design ribbon tab

In the Data group click Select Data

On the form click Hidden and Empty Cells

Select Show data in hidden rows and columns

[#3]

Perfect answer thank you

@Peter Bartholomew