Dynamic y axis on graphs

**freud1** · 04-23-2009, 06:23 AM

Hi Guys,

I am pulling a series of data to place into graphs.

I need these graphs to have the same y axis max value as each other, however the data varies so i need this to change when i change the input data.

I cannot use the excel Auto function as this will change the y axis to diferent values for each chart when they need to all show the same value.

I cannot set them as a fixed value because when I change the input data this value may be too high or low.

Any ideas on a solution?

**Andy Pope** · 04-23-2009, 07:18 AM

The scales have 2 options auto or fixed.
You need to determine the fixed value for all the scales and then apply that to each chart via code.

Or if the auto option for the chart with the largest values is acceptable you can add a dummy series to each chart that plots that data, thus forcing all the charts to use the same auto values.

**freud1** · 04-23-2009, 07:34 AM

thanks for getting back to me andy, i dont quite undserstand what you mean.

I have 5 charts in total that I want to use the same scale, but these charts are populated by the data in the table which changes (from customer to customer)

for example, if it is graphing income, one customer may be spending aprox £10 per week, so i would want the scale at about 12 for all 5 charts, the next customer may spend £1000 per week so i would need the charts all at £1200.

the values on each chart may be weekday spend for one chart, and then weekend spend on another, weekend spend would be much lower but i would still like the chart to show the same scale as the weekday spend

hope this helps.

**Andy Pope** · 04-23-2009, 07:45 AM

which bit did you not understand?

Either use a VBA solution to fix all charts to a specific value, based on the data in all charts.

Or add a dummy series to each chart. This series would contain the values of the chart that has the largest value.

Can you create a 2 chart example to illustrate your problem?

**freud1** · 04-23-2009, 08:18 AM

thanks Andy,

here is an example sheet.

ideally i need the Max and Min demand charts to use the max demand scale.

and i need the average, max consumption and min consumption to use the scale of the Max Demand devided by 2.....

sorry to make it more complicated