View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
MikeR-Oz
 
Posts: n/a
Default 2 seperated cluster of bars on 1 bar graph?

OK - I have got the seperation I needed by reworking the data so that the
2004 months are all together(before each 2004 month had its 2005 partner next
to it) and then having a blank column followed by the months 2005 data. BUT
how can I het the same colour for the month in 2004 and 2005 the same ?i.e
november 2004 and 2005 say red , December 2004 and Decmber 2005 Green etc?
Mike

"MikeR-Oz" wrote:

I would like to have the data for the months of 2004 and then the same months
for 2005 on the one bar graph BUT all 2004 together on say the left of the
X-axis and then a space and the 2005 group clustered on the right of the
x-axis. is that possible?
Mike