excel intermediate

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 intermediate

Excel intermediate

resolvedResolved · Low Priority · Version Standard

Tim has attended:
Excel Intermediate course

Excel intermediate

How do I change the major unit values in a chart?

RE: Change Chart Axes Scales

Hi Tim,

After creating a chart, double click on the axes number to format it. Switch to SCALE tab and type in your preferred major unit, then press OK

Hope this helps.

Regards,

Katie Woo
Microsoft Certified Trainer


 

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


Server loaded in 0.09 secs.