Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column Chart
Hi,
XL2003 At work, we allocate a Labour Time for every job we have an order for. Im using a stacked column chart with 2 columns. The first column shows the total number of hours for all jobs. The second column shows the total number of labour hours available over a given period of weeks. I have found that I cant use my current chart if the total number of jobs is more than 255. I dont want to sum the job hours first, because the current chart allows the user to hover the mouse over each graphical segment, which brings up a comment-like box, with the name of the job, and the number of hours that segment represents which is useful. So, is there any way of using a stacked column chart with more than 255 thingies, or is there another type of chart I can use? Regards Dave. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column Chart
Hi,
Here are the 2007 limits: Charting specifications and limits Feature Maximum limit Charts linked to a worksheet Limited by available memory Worksheets referred to by a chart 255 Data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.) in one chart 255 Data points (data points: Individual values that are plotted in a chart. Related data points make up a data series. Data points are represented by bars, columns, lines, slices, dots, and other shapes. These shapes are called data markers.) in a data series for 2-D charts 32,000 Data points in a data series for 3-D charts 4,000 Data points for all data series in one chart 256,000 You have reached the limit. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Dave" wrote: Hi, XL2003 At work, we allocate a Labour Time for every job we have an order for. Im using a stacked column chart with 2 columns. The first column shows the total number of hours for all jobs. The second column shows the total number of labour hours available over a given period of weeks. I have found that I cant use my current chart if the total number of jobs is more than 255. I dont want to sum the job hours first, because the current chart allows the user to hover the mouse over each graphical segment, which brings up a comment-like box, with the name of the job, and the number of hours that segment represents which is useful. So, is there any way of using a stacked column chart with more than 255 thingies, or is there another type of chart I can use? Regards Dave. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column Chart
OK, thanks Shane. So be it then.
Regards - Dave "Shane Devenshire" wrote: Hi, Here are the 2007 limits: Charting specifications and limits Feature Maximum limit Charts linked to a worksheet Limited by available memory Worksheets referred to by a chart 255 Data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.) in one chart 255 Data points (data points: Individual values that are plotted in a chart. Related data points make up a data series. Data points are represented by bars, columns, lines, slices, dots, and other shapes. These shapes are called data markers.) in a data series for 2-D charts 32,000 Data points in a data series for 3-D charts 4,000 Data points for all data series in one chart 256,000 You have reached the limit. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Dave" wrote: Hi, XL2003 At work, we allocate a Labour Time for every job we have an order for. Im using a stacked column chart with 2 columns. The first column shows the total number of hours for all jobs. The second column shows the total number of labour hours available over a given period of weeks. I have found that I cant use my current chart if the total number of jobs is more than 255. I dont want to sum the job hours first, because the current chart allows the user to hover the mouse over each graphical segment, which brings up a comment-like box, with the name of the job, and the number of hours that segment represents which is useful. So, is there any way of using a stacked column chart with more than 255 thingies, or is there another type of chart I can use? Regards Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Chart Title With 3D Stacked Column Chart | Charts and Charting in Excel | |||
Excel 2003 - Combination chart: Stacked Column + Stacked Column | Charts and Charting in Excel | |||
Needed: Chart that combines clustered column and stacked column types | Charts and Charting in Excel | |||
How can I add a line chart in a stacked column chart style? | Excel Discussion (Misc queries) | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |