Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
hiding % characted in the Y axis using custom format
Few weeks ago I have seen a presentation where by using custom format it was
possible to format the Y axis so that it was displaying the % only next to 100 and all the rest of the axis was displaying numbers without %. It was like 100% 80 60 40 20 0 I do not remember the syntax of this custom format. Can someone refresh my memory ? How it was done ? Regards Tony |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
hiding % characted in the Y axis using custom format
Sounds like someone but a textbox over the 100 to make it 100%
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Tony" wrote in message ... Few weeks ago I have seen a presentation where by using custom format it was possible to format the Y axis so that it was displaying the % only next to 100 and all the rest of the axis was displaying numbers without %. It was like 100% 80 60 40 20 0 I do not remember the syntax of this custom format. Can someone refresh my memory ? How it was done ? Regards Tony |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
hiding % characted in the Y axis using custom format
If the values where plain numbers then try
[=100]General\%;General Cheers Andy Tony wrote: Few weeks ago I have seen a presentation where by using custom format it was possible to format the Y axis so that it was displaying the % only next to 100 and all the rest of the axis was displaying numbers without %. It was like 100% 80 60 40 20 0 I do not remember the syntax of this custom format. Can someone refresh my memory ? How it was done ? Regards Tony -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
hiding % characted in the Y axis using custom format
Thank you Andy, it is exactly what I was after.
Regards, Tony "Andy Pope" wrote: If the values where plain numbers then try [=100]General\%;General Cheers Andy Tony wrote: Few weeks ago I have seen a presentation where by using custom format it was possible to format the Y axis so that it was displaying the % only next to 100 and all the rest of the axis was displaying numbers without %. It was like 100% 80 60 40 20 0 I do not remember the syntax of this custom format. Can someone refresh my memory ? How it was done ? Regards Tony -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
hiding % characted in the Y axis using custom format
Hi Andy,
I was a bit too quick with replying. It is still not exactly what I want. It is showing now: 100% 0.8 0.6 0.4 0.2 while I would like to have: 100% 80 60 40 20 Could you please help me more. Regards, Tony "Andy Pope" wrote: If the values where plain numbers then try [=100]General\%;General Cheers Andy Tony wrote: Few weeks ago I have seen a presentation where by using custom format it was possible to format the Y axis so that it was displaying the % only next to 100 and all the rest of the axis was displaying numbers without %. It was like 100% 80 60 40 20 0 I do not remember the syntax of this custom format. Can someone refresh my memory ? How it was done ? Regards Tony -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
hiding % characted in the Y axis using custom format
I did say plain numbers, by which I meant not those being converted to
percentages. The % in the number format not only adds the % sign it also multiplys the value by 100. I don't think you can lose the % sign with your data. You would need to use a helper column to factor up the values first. Maybe you could contact whoever gave the presentation and ask how they did it? Cheers Andy Tony wrote: Hi Andy, I was a bit too quick with replying. It is still not exactly what I want. It is showing now: 100% 0.8 0.6 0.4 0.2 while I would like to have: 100% 80 60 40 20 Could you please help me more. Regards, Tony "Andy Pope" wrote: If the values where plain numbers then try [=100]General\%;General Cheers Andy Tony wrote: Few weeks ago I have seen a presentation where by using custom format it was possible to format the Y axis so that it was displaying the % only next to 100 and all the rest of the axis was displaying numbers without %. It was like 100% 80 60 40 20 0 I do not remember the syntax of this custom format. Can someone refresh my memory ? How it was done ? Regards Tony -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
hiding % characted in the Y axis using custom format
Hi Andy,
I have what I wanted. I have created another column with percentage values multiplied by 100 and used the following custom format: [=100]General\%;General It is displaying now what I wanted. Regards, Tony "Andy Pope" wrote: If the values where plain numbers then try [=100]General\%;General Cheers Andy Tony wrote: Few weeks ago I have seen a presentation where by using custom format it was possible to format the Y axis so that it was displaying the % only next to 100 and all the rest of the axis was displaying numbers without %. It was like 100% 80 60 40 20 0 I do not remember the syntax of this custom format. Can someone refresh my memory ? How it was done ? Regards Tony -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Format for User Defined Function | Excel Discussion (Misc queries) | |||
adding custom format | Excel Discussion (Misc queries) | |||
Is it possible to create your own custom format? | Excel Discussion (Misc queries) | |||
Custom Format for hours and minutes | Excel Discussion (Misc queries) | |||
Reference Cell in custom format???? | Excel Discussion (Misc queries) |