Chart Series colours

[radder33]

Hello

I have set up a chart to run off some graphs plotting cutomer turnover. The problem I have is that the graphs gather data from 2009 onwards and if a customer didnt start trading until after that it throws out the series colours. The colours seem to be counting by series rather than year, so to explain as best I can.

Customer A

2009 - Green
2010 - Yellow
2011 - Blue
2012 - Red

Customer B

2010 - Green
2011 - Yellow
2012 - Blue

Is there a way by VBA or other setting so that I can lock the data series to the year rather than the series count?

 

[dhookom]

Create a query that returns the missing years. I might help if you provided the Row Source SQL statement and/or the significant tables and fields.

Duane
Hook'D on Access
MS Access MVP