To swap primary and secondary Y axes, you need to have both primary and
secondary X axes, at least temporarily. Format the scale of each horizontal
axis, checking Value Y Axis Crosses at Maximum for one, unchecking it for
the other. Then if you needed to add it, remove the secondary category axis.
I have tried several times to update the scale of the primary which is
percentage of shipments type (ie 50-100%) and the secondary is amt of
shipments in millions (ie 0-45)
with data like this
Total Ship Count 36,467,496 32,039,170
Automated 31,986,666 27,818,094
Vendor Manual 4,098,784 3,859,498
CFSC/Ops Manual 382,046 361,578
When I update the percentage scale it just reverts right back to the
original value as if I had not changed it.
I never use the display units. I use a number format that suppresses the
extra digits (put a comma at the end for each set of three zeros to omit),
and add the appropriate text to the axis title.
- Jon
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.