Conditional formatting on charts
 

On a graph that shows amount of money that I spend per day, how can I make
its markers that correspond to weekend on a different colour?

I would like to do this automatically and no manually as I am doing now.

Thanks.

Conditional formatting on charts
 

If dates are in column A and expenses in column B, in C1, enter the formula
:
=IF(OR(WEEKDAY(A1)=7,WEEKDAY(A1)=1),B1,NA())
in D1, enter the formula :
=IF(ISNA(C1),B1,NA())
drag down as necessary and create your chart with data from columns C and D.
--
Regards.
Daniel
"Maglez" a écrit dans le message de news:
...
On a graph that shows amount of money that I spend per day, how can I make
its markers that correspond to weekend on a different colour?

I would like to do this automatically and no manually as I am doing now.

Thanks.

Conditional formatting on charts
 

Here is an illustrated tutorial:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Maglez" wrote in message
...
On a graph that shows amount of money that I spend per day, how can I make
its markers that correspond to weekend on a different colour?

I would like to do this automatically and no manually as I am doing now.

Thanks.