View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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.