Excel 2010 chart column colour

[bibblebub]

I have a column chart for which the X axis is the day number of the current year, i.e. Jan 1st = 0, Jan 2nd = 1... Dec 31st = 365 (since it is a leap year). I want to change the colour of the column for today (only) so that it is different from the default for the chart e.g. the column for today's value to be yellow to stand out from all the other days which have a blue column colour.

How do I conditionally format a single column in a chart?

[Aquariel]

There are no settings in the chart options to easily do it.

However, you can do it another way. What you need to do is to create two temporary data series and use a formula based on the current day of the year to put the data into the relevant series from your master data, i.e. series 1 should contain everything but today's info, which should be 0; series 2 contains all 0 except today's info. This should update automatically depending on the date.

Then create a stacked bar chart from the 2 series - the 0 cells will make it appear as there is only one column for each day. You can then format the colour for each series, and only today's will show up in a different colour.

I hope that makes sense!

[bibblebub]

Thank you Aquariel, that does indeed make sense.

[bibblebub]

...and it works ok. Shame that there's no way to do it directly without having to set up a secondary data series.