Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

	98.1 % recommend us
	More live stats...

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

Training information:

Excel

Resolved · Low Priority · Version 2007

Reply Mon 12 May 2008, 16:58Delegate Jonathan said...

Jonathan has attended:
Excel Introduction course

Excel

When a chart is created can one change the axis or are they determined by the horizontal and vertical rows/columns of the spreadsheet. What is the default, i.e. the vertical/left hand column creates which axis? Many thanks.

Jonathan

For upcoming training course dates see: Pricing & availability

Reply Sun 18 May 2008, 18:14Trainer Alan said...

RE: Excel

Hi Jonathan

Click on the chart and then go to the dropdown on the chart toolbar. Choose the Axis you want to change and edit it!

You could also point directly at the axis, right click and choose the FORMAT AXIS option from the shortcut menu.

Excel articles

· From the Classroom to the Corporate World
· Finding Your Way Around Excel 2007
· Tips to Facilitate Printing of Excel worksheets
· Don't Get Lost In A Sea Of Data, Use Excel Navigation
· Working Together Is Easier Than Ever With Excel 2010

Please browse our web site to find out more about
vba excel course london and other Microsoft training courses.

Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant

View all Excel hints and tips