Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting of x axis
I have a chart and on the x axis I have days (January 1st 2005 - January 31
2005). What I woul like to be able to do is HIGHLIGHT in red specific days (for example weekends. In this case (Jan 1 and 2nd, 8, 9th, 15th, 16th, 22,23, 29 30) is this possible if so how (All other days in the x axis should remain as Black. Thank you very much! Regards Charles |
#2
|
|||
|
|||
Dear Charles,
Next will be an ugly trick! But it works in a way, in Excel XP. Put <spaces before all saturdays, sundays *and* mondays. Include these cells when you create your chart. The weekends will stand out by enlarged marker lines. There will be a better way by using intelligent VBA. But I'm not intelligent. I first tried conditional formatting by =OR(MOD(D6-38353;7)=0;MOD(D6-1-38353;7)=0) That works fine in worksheet cells but it doesn't show in the chart. Frans "Charles" wrote in message ... I have a chart and on the x axis I have days (January 1st 2005 - January 31 2005). What I woul like to be able to do is HIGHLIGHT in red specific days (for example weekends. In this case (Jan 1 and 2nd, 8, 9th, 15th, 16th, 22,23, 29 30) is this possible if so how (All other days in the x axis should remain as Black. Thank you very much! Regards Charles |
#3
|
|||
|
|||
Thank you. I'll try tis out!
"Frans van Zelm" wrote: Dear Charles, Next will be an ugly trick! But it works in a way, in Excel XP. Put <spaces before all saturdays, sundays *and* mondays. Include these cells when you create your chart. The weekends will stand out by enlarged marker lines. There will be a better way by using intelligent VBA. But I'm not intelligent. I first tried conditional formatting by =OR(MOD(D6-38353;7)=0;MOD(D6-1-38353;7)=0) That works fine in worksheet cells but it doesn't show in the chart. Frans "Charles" wrote in message ... I have a chart and on the x axis I have days (January 1st 2005 - January 31 2005). What I woul like to be able to do is HIGHLIGHT in red specific days (for example weekends. In this case (Jan 1 and 2nd, 8, 9th, 15th, 16th, 22,23, 29 30) is this possible if so how (All other days in the x axis should remain as Black. Thank you very much! Regards Charles |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |