Hide data range for a graph

[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.

 

[Debra Dalgleish]

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