Forum Discussion
Solved
Dissapearing Chart Data
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 whic...
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
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