excel 2003 visual basic intermediate course - scale chart

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Scale of Chart

excel 2003 visual basic intermediate course - Scale of Chart

resolvedResolved · Low Priority · Version Standard

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?

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


 

Excel tip:

Reset Excel toolbars to default settings

If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

View all Excel hints and tips


Server loaded in 0.09 secs.