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 Home • MS Excel Intro
• Creating & Saving • Typing
& Formatting • Simple Formulas
• Sorting & Filtering • Clip
Art & Drawing • Freezing & Protection
• Charts & Graphs • Web
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. |