View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Will H. Will H. is offline
external usenet poster
 
Posts: 1
Default Excel Chart - Too many data points in Series?

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!