how can i create a chart that spans grouped cells?

F

frankherb

Have a line chart that spans columns (C:p, for example). Some of those
columns are grouped (say, F:J, for example).
When I view level-2 detail (all columns shown) the chart looks fine.
But when I view only level-1 detail the chart changes, not displaying the
collapsed columns.

Any way to keep the chart static?

Thanks.
 
L

Luke M

With your chart selected, go to
Tools->Options. Select Chart tab. Uncheck the "plot visible cells only" box.
You should now be able to hide the column and still have your chart work
correctly.
 

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

Weird issue with very simple line chart - urgent 3
How can I create a line chart with 800,000 data points 3
How can i resize a chart so that it has a different aspect ratio 1
Creating a chart using selected cells from worksheet 2
How do I create two stacked column graphs together? 5
How do I automatically create lists from column topics in a chart 0
How can I create Schedule Chart? 1
PowerPoint Powerpoint inserted chart changes data when I edit. 0

Top