Chart Help Please!

[Shhhh]

Hello all,

I have a very simple chart...

The data looks like this:

A B

Data1 3.65
Data2 7.00

The data charts fine and looks good but right now the bar for Data1
and Data2 are the same color. is there a way to have the bar for data1
one color while data2 is a different color?

Thank you all for you excellent help!!

 

[Gord Dibben]

In 2003

Select the series and Format Data Series>Options>Vary colors by point.

In 2007

Select the series and Format>Date Series>Fill>Vary colors by point.


Gord Dibben MS Excel MVP