Value axis - show as %

G

Guest

in my worksheet the data format 100% (no decimals) and in the value axis it
shows as 100000000000% - how can I change this to show as a max of 3 digits.
Thank you
 
J

Jon Peltier

This makes little sense, all those zeros. What is the actual value in the
sheet, and what is the actual number format in the sheet?

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Horizontal axis to the bottom 1
Problem w/X axis in chart (2003) 3
Negative values on X axis 6
Make Y-axis values correspond to x- axis value 1
Suppress higher values in y-axis 1
How do I put words as the Y axis values? 0
Conditional number format of x-axis based on value? 1
Editing secondary x-axis 1

Top