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! |
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! |
All times are GMT +1. The time now is 11:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com