Blonde Tutorials
 
Charts & Graphs

One of the most useful features of Excel is the ability to quickly and easily create great-looking charts and graphs from your data.

On the Standard Toolbar, click on the Chart Wizard icon (looks like a little bar graph).

The Chart Wizard window will appear and walk you through the chart-making process.

Step 1: Choose your Chart Type.
Check the description of each chart to find the best one for your data.

Click Next.

 


Step 2: Choose your Source Data.
Data Range and Series are where you will select the data that you want included in your chart.
Anytime you see a small box with a little red arrow, that is a place where you can click to choose the data that goes in that box.
For example, if you want to change the values for the series "Amount In", select "Amount In" in the Series box, then click on the little box at the right of the Values area. The whole window will shrink down so that you can see all of your data. Simply higlight the area of data that you want to include in "Amount In". Then click the little box again and the Source Data window appears again.

Click Next.


Step 3: Chart Options.
In this step you can add your chart title, add or remove the legend, and decide what labels your chart will have.

Click Next.


Step 4: Chart Location.
If you choose a "As new sheet", the chart will appear on a separate sheet in the workbook. Choosing "As object in" will place the chart on the same sheet as your data.

Click Finish.


When you click on your chart, the Chart Toolbar appears.
You can use the options on this toolbar to make changes in your chart.

FYI:
You CAN create a chart that covers filtered data.
Just run the filter, then create the chart.

Blonde Tutorials HomeMS Excel IntroCreating & SavingTyping & FormattingSimple FormulasSorting & FilteringClip Art & DrawingFreezing & ProtectionCharts & GraphsWeb Pages


All tutorials may be reproduced only in their original form with appropriate credit given to the owner/author.
Microsoft, Windows, Office 2003, Outlook Express, Outlook, Word, Excel, Publisher, PowerPoint and the respective logos are trademarks or registered trademarks of Microsoft.
All other original images and tutorials in this site are property of Early ISD, Copyright © 2005.
Please e-mail questions and comments to Ren Yantis, resident blonde.