Excel 2007 : Dependent Chart Series

Is there any way to have a chart automatically display the appropriate Y axis values, based on the associated criteria.

I have a series of charts invoked from a combo box, however some of the charts use £s, others just numbers. My problem is, that if I format my first chart to display, say £s then all the charts that follow also display £s, I want the charts to display the values, (including changing from eg. millions to tens in terms of units) appropriate to each chart.

I've attached a sample that hopefully demonstrates the problem, all the charts display £ values where I need some to display some values just as numeric values with no decimal points...