Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Chart - Too many data points in Series?
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 "Will H." <Will wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Draw a chart line connecting 2 points in the middle of the series | Charts and Charting in Excel | |||
not able to link chart points from same series | Charts and Charting in Excel | |||
Line chart with two series; how to add points to one and not the other? | Charts and Charting in Excel | |||
Points in between Data Series | Charts and Charting in Excel | |||
Trendline excluding last 2 data points of series | Charts and Charting in Excel |