L
Leslie
Some time ago, I asked about two y axes on a chart, the left of which showed
whole numbers from 0 to 16 and the right of which showed whole numbers from
0 to 55. I wanted to hide the only number above 12 on the left axis (16) and
hide all numbers below 40 on the right axis (0-35).
Jon Peltier told me to use custom number formats for both axes, [>=16]" ";0
for the left and [<40]" ";0 for the right.
That worked fine.
The chart I was then asking about was one I had created for practice.
I've now tried to create my "real" chart. The values from which the columns
on that chart are derived come from cells which are formatted as percentages
to one decimal place. That has led the labels on the two y axes each to
show, not the simple numbers 0-16 and 0-55 respectively, but the percentages
0.0% to 16.0% and 0.0% to 55.0% respectively.
The custom number formats Jon Peltier told me to use for the first chart
don't work for the second chart. If I use them unedited, they cause both y
axes to show "0" at every tick. I edited the formats myself, trying
different things, but nothing I tried achieved the correct outcome.
I'd appreciate being informed how to amend the number formats so that the
left axis shows only 0.0% to 12.0% and the right axis shows only 40.0% to
55.0%.
Thanks.
whole numbers from 0 to 16 and the right of which showed whole numbers from
0 to 55. I wanted to hide the only number above 12 on the left axis (16) and
hide all numbers below 40 on the right axis (0-35).
Jon Peltier told me to use custom number formats for both axes, [>=16]" ";0
for the left and [<40]" ";0 for the right.
That worked fine.
The chart I was then asking about was one I had created for practice.
I've now tried to create my "real" chart. The values from which the columns
on that chart are derived come from cells which are formatted as percentages
to one decimal place. That has led the labels on the two y axes each to
show, not the simple numbers 0-16 and 0-55 respectively, but the percentages
0.0% to 16.0% and 0.0% to 55.0% respectively.
The custom number formats Jon Peltier told me to use for the first chart
don't work for the second chart. If I use them unedited, they cause both y
axes to show "0" at every tick. I edited the formats myself, trying
different things, but nothing I tried achieved the correct outcome.
I'd appreciate being informed how to amend the number formats so that the
left axis shows only 0.0% to 12.0% and the right axis shows only 40.0% to
55.0%.
Thanks.