- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
change of color on barchart
Hi,
Have a simple combochart showing result vs budget with full ackumulation; (bars is result, and line budget)
What Id like is that bars after july (since aug numbers isnt in yet) should be a diffrent shade. Ofcourse this should be dynamic so when its september, then okt and onward should be a diffrent shade.
Made a small example with just the core numbers if you need something to play around with.
Thanks in advance!
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try a background expression like this
=If(Month(Date#(Only({1} Month), 'MMM')) < Month(Today(1)), RGB(154, 198, 188), ARGB(100, 154, 198, 188))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try a background expression like this
=If(Month(Date#(Only({1} Month), 'MMM')) < Month(Today(1)), RGB(154, 198, 188), ARGB(100, 154, 198, 188))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this as BG color?
If(MonthNum <= Num(Month(Today())), Green(), Yellow())
Where as MonthNum created by script like Num(Month(Date#(Month,'MMM')))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks!
Just what I wanted.