Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert number to % using only custom number format challenge
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert number to % using only custom number format challenge
http://peltiertech.com/Excel/ChartsH...venScales.html
On 2 Cze, 10:44, Brotherharry wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert number to % using only custom number format challenge
Nice, although complex. Doesn't make it easy to compare lines in the
same space as your eye has to jump between all three panels. On Jun 2, 10:03*am, Jarek Kujawa wrote: http://peltiertech.com/Excel/ChartsH...venScales.html On 2 Cze, 10:44, Brotherharry wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert number to % using only custom number format challenge
yet another hint:
http://peltiertech.com/Excel/Charts/BrokenYAxis.html also have a look at http://peltiertech.com/Excel/Charts/DummySeries.html On 2 Cze, 11:27, Brotherharry wrote: Nice, although complex. Doesn't make it easy to compare lines in the same space as your eye has to jump between all three panels. On Jun 2, 10:03*am, Jarek Kujawa wrote: http://peltiertech.com/Excel/ChartsH...venScales.html On 2 Cze, 10:44, Brotherharry wrote: 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?- Ukryj cytowany tekst - - Poka¿ cytowany tekst - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert number to % using only custom number format challenge
also browse
microsoft.public.excel.charting for possible answers On 2 Cze, 11:50, Jarek Kujawa wrote: yet another hint: http://peltiertech.com/Excel/Charts/BrokenYAxis.html also have a look at http://peltiertech.com/Excel/Charts/DummySeries.html On 2 Cze, 11:27, Brotherharry wrote: Nice, although complex. Doesn't make it easy to compare lines in the same space as your eye has to jump between all three panels. On Jun 2, 10:03Â*am, Jarek Kujawa wrote: http://peltiertech.com/Excel/ChartsH...venScales.html On 2 Cze, 10:44, Brotherharry wrote: 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?- Ukryj cytowany tekst - - Poka¿ cytowany tekst -- Ukryj cytowany tekst - - Pokaż cytowany tekst - |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert number to % using only custom number format challenge
On Tue, 2 Jun 2009 01:44:22 -0700 (PDT), Brotherharry
wrote: 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? Have you considered using a semi-logarithmic scale? You could multiply your percent figure by 100,000; and then use this custom format: 0.0,\% (to display with one decimal). --ron |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert number to % using only custom number format challenge
Aha, that's exactly what I was looking for.
I multiplied my % values by 100,000 and plotted them directly, removing the marker points and lines, but adding formatted data labels using your custom number format. Lose some control over the position, but adequate for my needs right now. On Jun 2, 11:19*am, Ron Rosenfeld wrote: You could multiply your percent figure by 100,000; and then use this custom format: 0.0,\% *(to display with one decimal). --ron |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert number to % using only custom number format challenge
On Tue, 2 Jun 2009 08:01:46 -0700 (PDT), Brotherharry
wrote: Aha, that's exactly what I was looking for. I multiplied my % values by 100,000 and plotted them directly, removing the marker points and lines, but adding formatted data labels using your custom number format. Lose some control over the position, but adequate for my needs right now. Glad to help. Thanks for the feedback. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom number format for driver's license number | Excel Discussion (Misc queries) | |||
Custom number format | Excel Discussion (Misc queries) | |||
Moving custom number format to NUMBER | Setting up and Configuration of Excel | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) |