Sounds like the root issue is how to force a series to one axis or the
other.

Anybody know what the property in question is?

mySeries.AxisGroup = xlSecondary ' or xlPrimary

At least one series (not necessarily the first) must be on the primary axis.

Regards,
Peter T



"(PeteCresswell)" wrote in message
...
Per (PeteCresswell):
But I still have two different types of values: one instantaneous and the
other
cumulative.

OTOH, I guess from the user's perspective it's moot as long as the single
axes
has enough span to accommodate both. Better, maybe bc now the lines and
the
bars are comparable.

Going to a simple column chart and coercing the series to column or line
has the
desired result.

But I still have a problem.

Turns out that the bars are for instantaneous values and the lines are for
cumulative values. After a year or two, the cumulative values will
become very
large compared to the instantaneous values - so two axes really are
necessary.


Sounds like the root issue is how to force a series to one axis or the
other.

Anybody know what the property in question is?
--
PeteCresswell