Hide data range for a graph

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Select the chart
Choose Tools>Options
On the Chart tab, remove the check mark from 'Plot visible cells only'
Click OK
 
Back
Top