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

charts

ResolvedVersion 2003

Lesley has attended:
Excel Introduction course

Charts

how do i create a chart

RE: charts

Hi Lesley,

Thank you for your question.

There are two methods to create charts.

1. Select the data on the spreadsheet you want to chart and press F11(function key). A new sheet will appear with your Bar Chart. Then use the Chart menu and the chart toolbar to edit the chart.

2. Use the Insert Chart command and a the Chart Wizard will begin:
i. Select the chart type
ii. With the mouse select the data that you want to chart
iii. Add any Titles for the chart or axis
iv. The final step is to tell excel where to place the chart.

Then use the Chart menu and the chart toolbar to edit the chart.

I hope this answers your question.

Regards

Simon

Excel tip:

Adding up rows or columns without seeing formulas

Highlight a column or row and click the Autosum button. This gives you your answer without showing the formula.

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.09 secs.