Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel 2003 visual basic intermediate course - Scale of Chart

Resolved · Low Priority · Version Standard

Reply 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?

For upcoming training course dates see: Pricing & availability

Reply 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

Excel articles

· How to check for and reduce errors in Microsoft Excel
· So Can You Really Sort On Colours In Excel 2007?
· Find Out How To Create That Missing Link With Excel
· How To Create A Data Table In Excel 2010
· Learn How To Separate Text In Excel Into Separate Cells

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips