Colour in Bar Graphs

[jaya]

Is it possible to have different colours on the bars for the same series in a bar graph? I would like to have one colous for revenues to date and a different colour for forecast revenue, the latter being a continuation of the former.

 

[SydneyGeek]

You'll need 2 different data series -- Revenue to Date and Future Revenue. Set up as adjacent cols on your worksheet, then create a stacking bar graph.

Denis

 

[jaya]

Thanks, it works