Hide data range for a graph

G

Guest

When I hide the data range for the bar graph, a blank
graph except the graph title appears eventhough I checked
back the data range, it still shows the original data
range before the data range is hidden.

Would appreciate your help on this.

Thank you.
 
D

Debra Dalgleish

Select the chart
Choose Tools>Options
On the Chart tab, remove the check mark from 'Plot visible cells only'
Click OK
 
Top