chart axis conditional formating

[phil_r]

Hi,
I have to produce regularly a graph that shows actual values as well as forecasts. Actuals and forecasts are stored in the same database (same format).
On the X axis, there are the monthes (Jan-Dec).
Is it possible to make the forecast monthes appear in a different color (either the data bar or the month name on X axis)to show the difference.
Something like: If(month>actual month;(then) write month in red; (else) write month in blue)
Any help would be appreciated.
Regards
Phil

 

[Andrew Poulsom]

Don't know about the labels but you can plot two series and make them different colours. If actuals exist make your forecast = #N/A. If there are no actuals make them #N/A. The #N/A values will not be plotted.