Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart Value axis
The chart I just made has values of 10%, 20%,30%, 40% and 50%. How do I make
it only show the % sign next to the 50 at the top and not next to the other numbers? Thanks damian |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart Value axis
You'll have to plot numbers not percentages (percent time 100), then use a
custom number format: [=50]0"%";0_% The % in quotes means use a % character without using a percent format, the _% means skip a blank space as wide as a 5 character, so the numbers line up. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Damian" wrote in message ... The chart I just made has values of 10%, 20%,30%, 40% and 50%. How do I make it only show the % sign next to the 50 at the top and not next to the other numbers? Thanks damian |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart Value axis
Thanks!That really helped me out.
"Jon Peltier" wrote: You'll have to plot numbers not percentages (percent time 100), then use a custom number format: [=50]0"%";0_% The % in quotes means use a % character without using a percent format, the _% means skip a blank space as wide as a 5 character, so the numbers line up. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Damian" wrote in message ... The chart I just made has values of 10%, 20%,30%, 40% and 50%. How do I make it only show the % sign next to the 50 at the top and not next to the other numbers? Thanks damian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to manually switch data from x axis to y axis in line chart? | Charts and Charting in Excel | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel |