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

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

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