May 05 2019 04:52 AM
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
May 05 2019 08:48 AM
SolutionSelect 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
May 05 2019 08:48 AM
SolutionSelect 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