I have a chart with about 6 sets of data in it.
The values between sets vary widely e.g. one set has data in the
millions, the others have data in the thousands but one in data in %
i.e. less than 1.
I can split the sets of data across two axis, so the millions stuff
goes on one axis and the thousands on the other, so I can see side by
side.
However, the % data series is obviously too small to appear and I've
run out of axis to show it on

So, I thought, what if I multiply the source % figure by 10,000 to get
be a number in the thousands so it can be plotted on my thousands
axis, but then apply a custom format so I can still see the 'real' %
figure on the data label?

ie. a custom number format that would look something like this [ # /
10,000] %

any ideas or workarounds?