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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

selecting and viewing a range 1
Combining a 2-D column graph and a 2-D line graph on the same char 3
max number of data ranges (bars) in a bar chart 5
Chart content to change according to a selection on a combobox 1
create hourly graph from half hour data 0
Named range as chart data reference (error) 8
Excel How to create a stacked bar graph 0
Data label doesn't match data point! 4

Back
Top