Thu 6 Dec 2007, 13:41Delegate Sara said...
Sara has attended:
Excel Intermediate course
Scale of Chart
I've right clicked the mouse to show "format Axis" and clicked on this, I'm trying to get the numbers for the scale to appear as I type them in as it is for weights but when I type in the information needed the scale always comes up as missing a 0 on the end. Does anyone know what i am doing wrong?
Thu 13 Dec 2007, 16:42Trainer Amanda said...
RE: Scale of Chart
Hi Sara
Thank you for your question, and apologies for the delay in replying.
If the scale is coming up missing numbers, then it is either to do with the way the numbers have been entered into the spreadsheet; or it is to do with the number formatting for the axis. If you go to Format Axis and then to the Number tab and try changing the number formatting there, does this help?
Amanda
