Chart Help Please!

  • Thread starter Thread starter Shhhh
  • Start date Start date
S

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!!
 
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
 
Back
Top