G
Glenn
I'm trying to create to a column and line graph (Excel
2002). The columns are import and export values and the
lines are expected variations as percentages.
The columns are fine, but line scale on the secondary
axis is not playing ball!
I can't get the zero value on the secondary axis to align
with the zero value on the primary axis.
The % values vary from 15% to -25% but the zero value is
3/4 the way up the axis, not at the bottom, like the
primary axis.
The category X crosses at zero option is checked, but
there isn't any change
Is there a way to do this?
2002). The columns are import and export values and the
lines are expected variations as percentages.
The columns are fine, but line scale on the secondary
axis is not playing ball!
I can't get the zero value on the secondary axis to align
with the zero value on the primary axis.
The % values vary from 15% to -25% but the zero value is
3/4 the way up the axis, not at the bottom, like the
primary axis.
The category X crosses at zero option is checked, but
there isn't any change
Is there a way to do this?