Line Chart: different font colors in x-axis captions

[#1]

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

[Gysbert_Wassenaar]

See attached example.