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

charts

ResolvedVersion 2003

Betty has attended:
Excel Intermediate course

Charts

How do I change the axle on charts

RE: Charts

Hi Betty

Thank you for your question

If you right click on the axis and select format axis then you can alter the following

Font properties. You can change the fontype, colour and style

Scale. You can alter the default scale of the axis, specifying major and minor units as well as the range covered

Number. You can specify how the number is presented, e.g. Currency, percentage etc,

Alignment. The orientation of the axis labels

Regards

Stephen

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.