Back | Back To Start | Next

To use the Chart Wizard :

Enter the data into the worksheet and highlight all the cells that will be included in the chart including headings.

NOTE: The first cell you highlight will remain white. It is highlighted, so don't worry.

Click theChart Wizard button.

Choose the Chart type and the Chart subtype.

Click Next.

Chart Options

Enter the name of the chart and titles for the X- and Y-axes.

Press Next to move to the next set of options.

Chart Location

Click

As new sheet if the chart should be placed on a new, blank worksheet.

or

As object in if the chart should be put in a separate worksheet.

Click Finish to create the chart.

Resizing the Chart

To resize the chart, click on its border and drag any of the nine black handles to change the size.

Chart Formatting Toolbar

First, click on the chart.

Chart Type - Click the arrowhead on the chart type button to select a different type of chart.

Legend Toggle - Show or hide the chart legend by clicking this toggle button.

Angle Text

Select the category or value axis and click the Angle Downward
or
Angle Upward button to angle the the selected by +/- 45 degrees.

This is useful for making all the labels on the axis show.

Copying the Chart to Microsoft Word
A finished chart can be copied into a Microsoft Word document. Select the chart and click Copy. Open the document in Word and click Paste.

Links to other Excel Online Tutorials:

Excel Full Online tutorials - Excel full tutorial covering most of the functional and operational questions.

MS Excel Very big basic tutorial Tutorial - In this tutorial you get a look into all the required basics. From easy basics of a spreadsheet to charts and graphs.

MS Excel Microsoft Excel - Office 2000 / XP Tutorial - Tutorial covering excel basics including: opening excel, entering data, aligning text, ending a sum and using charts.

MS Excel Tutorials and Projects - Excel spreadsheet creation and projects to help you create your first spreadsheets.

MS Office Training Courseware - Microsoft Office basic programs training and tutorials courseware. Course contains MS Excel, MS Word, MS Access, MS PowerPoint, MS Project and Windows XP Fundamentals. All materials are available for free download.

Merging Cells in Excel - Making your worksheets more "readable" by merging cells.

The Best Chart Types - Choosing a Chart Type For Your Spreadsheet.

Excel Printing - All You Need to Know - How to print properly from excel questions and answers.

Excel Functions and Formulas - This excel tutorial is providing the basics about formulas and functions.

Suggested Reading

Home | About Us | Our Services | Software | Spreadsheets Library | Excel Tutorials | Useful Links | Site Map | Contact Us

| Terms of Conditions |

Unless otherwise stated, all images and text
Spreadsheet123