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 resize a chart so that it has a different aspect ratio 1
How can I create a line chart with 800,000 data points 3
How to make a time phased line chart 0
How do I create a scrolling line chart? 0
I can't figure out how to hold chart references firm when inserting data 2
Creating a preato from a group of data choosen from a pivot chart 0
How to create a complicated pie chart 0

Top