Thread: Selected Non-Contiguous Data Not On Axis

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)

Note the two commas just inside the left hand bracket

Between the first and second comma enter the following:

Code:

'Semiannual Financial Projection'!$B$3:$G$3

The formula should now look like this:

Code:

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

The syntax for a the chart formula is :
=SERIES([Series Name] comma [Axis labels reference] comma [Series values])

Hope this helped

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?

Yes, the software has the latest service pack installed.

Is it worthwhile going back to SP1 or to try re-installing Office?

Thanks Andy. I will mark this problem solved.