Excel 2007 : Dependent Chart Series

**HangMan** · 07-09-2011, 05:41 AM

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...

**Andy Pope** · 07-09-2011, 05:53 AM

If you use a dynamic named range instead of the INDEX table approach and set the axis number format to linked to source the scale will automatically change.

I will close your other thread. No need to post in multiple forums.