H
HS Hartkamp
Hello all,
I have four graphs that are related, and they should have the same scaling
on the (vertical) value-axis.
Is there a way to make this happen automatically without using VBA-code ?
(i.e. set the scale on the first, and then the other three will use the same
settings, perhaps based on values in cells or something)
I can think of putting all four series in all four graphs, with one line
visible and the other three hidden, so that excel will automatically scale
the four to the same min-max values. The drawback is that this is often not
the best choice of scale, and changing one will leave the other three
unchanged.
If this is not possible, what is the most effective place / event to put the
VBA-code ?
Thanks in advance,
Bas Hartkamp.
I have four graphs that are related, and they should have the same scaling
on the (vertical) value-axis.
Is there a way to make this happen automatically without using VBA-code ?
(i.e. set the scale on the first, and then the other three will use the same
settings, perhaps based on values in cells or something)
I can think of putting all four series in all four graphs, with one line
visible and the other three hidden, so that excel will automatically scale
the four to the same min-max values. The drawback is that this is often not
the best choice of scale, and changing one will leave the other three
unchanged.
If this is not possible, what is the most effective place / event to put the
VBA-code ?
Thanks in advance,
Bas Hartkamp.