Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
in the x-axis of a Line Chart there are dates for each day in a month.
Now i want to highlight the saturdays and sundays in a different color then working days (mo-fr).
I load the dates from an excel file. In this excel file every date has a workingdaynumber (i.e. monday 1, tuesday 2.... saturday 6 and sunday 7). In the chart i have two dimensions: plattform and date. The y-axis represents the sum of listings.
In Properties - Axis - Dimension Axis - Font Type - Color i have created a new formula: If(workingdayno=6, Green(),red())
But it doesn't work! Each date is displayed in Red!
Can somebody help me?
Thanks and best regards from germany,
Sabrina
See attached example.