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+vba+training - Excel

	98.1 % recommend us
	More live stats...

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

Training information:

excel+vba+training - Excel

Resolved · Low Priority · Version Standard

Reply Mon 4 Feb 2008, 15:54Delegate Giulia said...

Giulia has attended:
Excel Intermediate course

Excel

How do you label axes and assign a graph title in excel?

For upcoming training course dates see: Pricing & availability

Reply Wed 6 Feb 2008, 12:02Trainer Richard said...

RE: Excel

Hello Giulia,

Hope you enjoyed your Microsoft Intermediate training with us.

To create labels for Axes, you need to go to the Chart Wizard.

MENU
Once you have completed the Chart Wizard, you can return by clicking on the CHART menu option on the toolbars. If there is no Chart option, then single click your chart and then you should see it.
Select the 3rd choice - CHART OPTIONS.
On the first tab you will see 3 boxes that you can edit the Chart titles.
Click Finish

ON CHART
Once you have the Axes and Titles for the chart complete, you can edit then by simply double clicking on them in the chart. They will open up like a text box, and you can edit them directly on the chart.

I hope this resolves your question. If it has, please
mark this question as resolved.

If you require further assistance, please reply to this
post. Or perhaps you have another Microsoft Office
question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer

Excel articles

· Plug Into The Big Grid
· Importing Useful Information From The Web To Excel
· How To Create An Excel Formula Using Data From Several Worksheets
· Charting Your Success With Excel 2007
· Break The Mystery Of Code With Excel Macros

Excel tip:

Create a hyperlink navigation sheet

In large files, it is often useful to have a front sheet with hyperlinks to the key databases and summary calculations in your spreadsheet. Hyperlinks can save you and (more importantly) those less familiar with your spreadsheet a great deal of pointless scrolling between and within sheets.

Hyperlinks appear as underlined text and can jump to any cell or range name in your file. You can also use hyperlinks to jump to other files.

To create a hyperlink to a location in the active workbook: (1) Select the cell that contains the text you want to use as the hyperlink and choose Insert|Hyperlink.(2)Click Place in this document.(3)Choose the sheet you want to link to or the range name from the list of "Defined Names".(4)If necessary, type the cell reference in the Type in the cell reference box. (5) Click OK.

View all Excel hints and tips