View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
gtslabs
 
Posts: n/a
Default Plotting Bands for Task Overlaps

I am trying to create a chart with horizontal bands (similar to a bar
chart) but I need the color of the band to change with different dates.
For instance from:
01/01/2000 to 06/01/2000 plot Blue
03/01/2000 to 06/06/2000 plot Red
04/01/2000 to 07/06/2000 plot Yellow

My intention is to have 1 band with different colors based on a task
length. Then have multiple bands stacked so I can visualy check for any
overlaps in colors(tasks)

Right now my data is in 2 colums: Start Date Task Name


Thanks in advance
Steve