charts

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

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

Charts

resolvedResolved · Low Priority · Version 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

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Selecting blank cells within a range of data

Select the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks.

View all Excel hints and tips


Server loaded in 0.08 secs.