Excel Chart - Too many data points in Series?

[Will H.]

I am working on a master data sheet for my 25 sales people and tracking their
progress every month. Other than the master worksheet, I also have 25 other
worksheets so I can visually graph each employees' data. 1 graph per sheet
(tab). As I go through the Create Chart wizard, I have 12 pieces of data in
12 different non-adjacent cells. Excel will only let me select 11 cells
located on the Master Sheet. Once I select the December data, my PC *dings*
and the Source Data - Values disappears back to 0.

Surely Excel 2003 11.8231.8221 SP3 will let me graph more than 11 data
points in a series? I created a new blank worksheet, and was only able to
select 18 non-adjacent cells for a data series. Am I doing something wrong?
Thanks for any help!

 

[Mike Middleton]

Will H. -

You may be exceeding the limit for the number of characters in a reference
to a data series.

Instead of referencing the non-adjacent cells, a work-around is to use
another single range on your worksheet that has the data in contiguous
cells, perhaps constructed by using cell references to the original
locations, and then use that single range for the chart.

- Mike Middleton
http://www.MikeMiddleton.com
Software and Books for Business Analytics