[SOLVED] Selected Non-Contiguous Data Not On Axis

dshedrow · #1 07-02-2009, 10:21 PM

When I select two non-contiguous areas on a spreadsheet - B3:G3 and B14:G14, and create a pie chart, the B3:G3 range (a list of months) does not show up on the axis.

Spreadsheet is attached.

Jbentley · #2 07-03-2009, 03:44 AM

Hi,
Does seem strange.. I downloaded your example file and created a new chart with the Month Names as Axis labels with no problem.

Anyway, a qucik one to fix:

Click on a pie segment in your chart.
If your formula bar you should see the following formula :

Code:

=SERIES(,,'Semiannual Financial Projection'!$B$14:$G$14,1)

dshedrow · #3 07-03-2009, 06:38 AM

Hi,

Thank you, your workaround works!

I use this example in a class I teach on Microsoft Office.

Many of the students run into this problem.

The spreadsheet seems to be broken. Sometimes you are able to generate the chart easliy and sometimes one of non-contiguous ranges fail to be generated. Another problem is that sometimes the months range doesn't show up on the axis but shows up as the legend. This can be seen when you bring up the select data dialog box. I generated another broken chart in this condition and have attached it.

I wonder if there is a bug in the Excel Charting software, or if I should have the software re-installed on all the machines in class?