How to double a y-axis range on charts?

[ChrisXcel]

I have code (below) that charts two series, each has its own y axis (left/right side).
The problem right now is that the chart shows the two series almost one on top
of the other.

I would like to expand the range of the right axis series, by doubling the values.
For example instead of one graph's values going from 0-5,000 they would go
from 0-10,000 etc.

Each chart has their own ranges according to the data, but doubling the
values for all the charts should separate the two series and make them easier
to view.

Any help in achieving this would be appreciated!

Please Login or Register  to view this content.

[bsalv]

you can modify the min and maxscale of each axis with this
Use our own values

Please Login or Register  to view this content.

[Andy Pope]

Why are you putting the 2 series in a single chart then?
If the series appearing near to each other is not a benefit why do it.

How about changing the chart type of 1 of the series?
Or starting one scale above the other, to create a small panel chart

[ChrisXcel]

you can modify the min and maxscale of each axis with this
Use our own values

Please Login or Register  to view this content.

Thanks bsaly.
The problem is that I have more than 100 charts and each one has different scales.
I need a dynamic way (VBA) of making each chart, on the fly.

[ChrisXcel]

Why are you putting the 2 series in a single chart then?
If the series appearing near to each other is not a benefit why do it.

How about changing the chart type of 1 of the series?
Or starting one scale above the other, to create a small panel chart

Thanks for helping out Andy.

I do want the two series on one chart, because that way I can clearly compare
one to the other time-wise.
If I place the charts next to each other I lose the time comparison.

As I mentioned above, because I have more than 100 charts, and they each have different
scales, I need code to take the min/max of each series and chart them accordingly.

Let me give you two examples.

In each example I would like the Series2 (orange) to use the left side scale and be higher in the chart.
And similarly I would like the Series1 (blue) to use the right side scale and be lower in the chart.

Right now they are one on top of each other and it's difficult to see the Series2 values well.

[bsalv]

The problem is that I have more than 100 charts and each one has different scales.
I need a dynamic way (VBA) of making each chart, on the fly.

change .MaximumScale = 100 into .MaximumScale = MyMax and calculate that value 1 line earlier.
I think you make it too difficult in your mind.

[ChrisXcel]

change .MaximumScale = 100 into .MaximumScale = MyMax and calculate that value 1 line earlier.
I think you make it too difficult in your mind.

Thanks bsalv.
I get the thrust of what you are suggesting, but I lack the programming skills to calculate the MyMax value.
Most of the code that I use to create my charts was written by Rory here. Really brilliant stuff!

Although I have written VBA stuff in Excel over the years, it was always been a painstaking effort
if I had to do everything myself, as I never learned any programming. If something worked, I was thrilled!

I don't know the declaring of variables (dim) etc. etc.
I know you can create loops and should avoid the use 'Select' etc. etc.
And I know what a Sub () is etc. etc.
But I don't really have the skill set to create charts on my own.