Hi:
Sorry to put you on the wrong foot! I didn't realise you have two series in
your chart. The option 'Vary color by point' only is available when you have
one series. Having two or more columns side-by-side in your chart, the only
thing I cld think of is to vary the colours of the columns by hand. Slowly
double-click the colomn you want to change (if you click too fast it will not
work). When the individual column is selected (see the handles shown as
black-filled squares around it), right-click and choose Format Data Point
from the pop-up menu. Select the Pattern tab. You can now choose the colour
you want (Area and/or Line of the column) for the selected column. Hint: the
colours below the thin line are the ones Excel select when using colours in
charts. By picking them from left to right for your data your colours will
be consistent with your other charts. (The first row is for fills; the second
one is used for lines).

I hope this helps.
Regards,
Henk

"RohanSewgobind" wrote:


I tried what you suggested however the vary colors by point option has
been diabled. Do you know why that may be?


--
RohanSewgobind
------------------------------------------------------------------------
RohanSewgobind's Profile: http://www.excelforum.com/member.php...o&userid=33724
View this thread: http://www.excelforum.com/showthread...hreadid=535065