Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Conditional formatting of charts | Charts and Charting in Excel | |||
Conditional Formatting for Charts | Charts and Charting in Excel | |||
conditional formatting in charts | Charts and Charting in Excel | |||
Conditional formatting backgrounds in charts | Charts and Charting in Excel | |||
Conditional formatting in Charts? | Charts and Charting in Excel |