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.
View best response
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
Perfect answer thank you