Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello QVer,
in a bar chart I want to visualisize a "Sunday"-bar in red colour; when Sunday is also an official holiday the bar should get a second pattern, frame etc.
Is that possible? How? Thanks. Greetings
could it be two separete colors (holiday - sunday)?
try to paste in expression background
=if(Date='2012-01-01' or Date='2012-01-06',red(),if(WeekDay(Date)=6,lightred()))
* you should list all the dates that are holidays in your country
Hello and thanks.
I've already done making those days red which are holidays.
Now I want to have all Sun- and Saturdays with a pattern and background coloured (i.e. red) when those days are official holiday. It should look like:
Greetings .
Hello,
any idea to assign two attributes to a bar of a bar chart as seen in my former posting?
Should mean i.e.: day is sunday (coloured red) and official holiday (pattern).
Thanks.Regards.
i'm afraid it is imposible:/
why dont you choose suitable colours
i mean....
lightred for sundays
colormix (lightred, darkgrey) for holidays
Thanks "Pari Pari".
I missed the "impossible" statement in your former Posting.
So I will try the colormix.
Regards.