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 » exce+training - Charts

	98.1 % recommend us
	More live stats...

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

Training information:

exce+training - Charts

Resolved · Low Priority · Version Standard

Reply Wed 5 Dec 2007, 09:55Delegate Dorab said...

Dorab has attended:
Excel Introduction course
Word Introduction course

Charts

How do I get started with charts

For upcoming training course dates see: Pricing & availability

Reply Wed 12 Dec 2007, 14:45Trainer Amanda said...

RE: charts

Hi Dorab

Thank you for your question - sorry about the delay in responding.

To create a chart:

Firstly you need to identify and select/highlight the spreadsheet data you wish to have represented in the chart. If the data is in adjacent columns or rows, this is easier. If the data is not in adjacent columns or rows (for example, the data is in columns A and D) highlight the first range of cells (in column A) then hold down the CTRL key and keep holding it down while you highlight the second range of cells (in column D). Then you can let go of the CTRL key and the mouse.

Secondly find the Chart Wizard button on the standard toolbar, and click it. This will take you through a 4 step process for creating your chart.

1. Select the type of chart
2. Preview the chart, and use the Series tab to make any adjustments if necessary.
3. Add chart titles and axes titles
4. Decide where you want the chart to be displayed - on the same sheet as the data or on it's own separate sheet.

I hope this helps.
Amanda

Excel articles

· Database Tips from an Excel Training Course
· Microsoft Excel can ensure you keep on top of your finances
· What's Better Than the Help Function in Excel? Microsoft Training
· Compare Different MS Excel Training Methods
· Microsoft Excel Training: Not Just for Newbies Anymore

Excel tip:

Change the Print button so it brings up the Print dialogue box

If you want to bring up the Print dialogue box to check your print settings when you hit the Print button, do the following:

1. Right-click on the toolbar that displays the Print button.

2. Select Customise.

3. Click on the Print button on the toolbar to select it, then hold the left mouse button down and drag the button towards the screen below. The button should come off the toolbar.

4. In the Customise dialogue box on your screen, select the Commands tab.

5. Select File from the Categories list, and then locate the Print... icon (looks like the normal Print button, but the word Print has three dots following it).

6. Click on the Print... icon to select it, then use your left mouse to drag and drop the icon onto the toolbar at the top of the screen.

7. Close the Customise dialogue box.

View all Excel hints and tips