Diffrent Colors for Weekdays

Question

Post reply

Diffrent Colors for Weekdays

orenk

Old Hand

Points: 388
More actions
August 27, 2015 at 3:25 am

#303806

Hallo,
a question whitch gives me a headache.
I would like to change the color for the weekends in interval of the timeline (see on screeshot). But nothing works...
Any ideas?
Thank for help
Olaf

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

pietlinden SSC Guru Points: 63506 More actions · Answer 1

Olaf,

I got it to work, sort of. (Well, in my bar graph.)

I created a simple bar graph with (Date, Value), so the x-axis represents dates. If you right-click on a bar in the graph, you can change the color rule. Go to Series Properties, and Fill. Then enter an expression like this one:

=IIF(Weekday(Fields!TheDate.Value)>=6,"Red","Automatic")

{6=Saturday, 7=Sunday}

Hope this helps,

Pieter

orenk Old Hand Points: 388 More actions · Answer 2

Hey Pieter,

thanks for help. I tryed, but it would not be working.

See what I have done in Screenshot. Maybe it is the wrong point to do that.

Thanks a lot

Olaf

pietlinden SSC Guru Points: 63506 More actions · Answer 3

Oh, I understand now. You wanted to change the color of the individual values on the timeline/X-axis when the value is on a weekend. Don't know how to do that one.... I tried using the formula there, and no joy.