How do I Change the background colour so that the current month ina chart is shown in a different colour to all other months?

[#1]

Hi there,

I was hoping someone chould help me with the code needed in the background colour.

I have a graph which displays sales for the months of the current year excluding the current month.

For example sales for 2013, Jan, Feb, Mar, April, May but NOT JUNE.

I would like the graph to show the previous months in one colour say blue and the latest month in another colour say yellow.

So for example, Jan, Feb, Mar, Apr in Blue and May in yellow. And then at the end of June, may will turn yellow and June will come into the graph as blue.

I was wondering if anyone could help me write this code to go into the background colour, or if you had any ideas on how to do this.

I would greatly appricate any help you could give me with this.

Thanks

[Gysbert_Wassenaar]

You're description of what you want is confusing. Have a look at the attached example. Click on the + in front of the expression, click on Background Color and look at the expression that's defined there. That should give you enough information to do what you want.

[Anonymous]

There is a [+] symbol to the left of each expression, and under there is a Background colour option.

In there, you can put an expression that tests if the month is less the today's month and if so put blue and if not yellow.

Such an expression could look like this:

    =if(Month<Month(Today()),lightblue(),yellow())

Jonathan

[#4]

Hi

I cant seem to open you document,

I know how to get into the background colour, but what I need is a peice of code that will allow me to display the current month in one colour and all of the past months in another colour?

Thanks