Welcome to Excelling with Excel 2007

Working Smarter

Charts
email me for the assignments
when you finish this, you are ready for the database and quiz

The fun part of Excel! And, so easy to do too.
Charts give a visual representation of information.
Charts in Excel are just too easy to do.
Email me for a chart sample. Be sure to check both sheet tabs of the sample.

The basic steps involve doing the following:

• select data
• click on the INSERT Tab
• select a Chart Type
• choose the desired chart
• and that is it ....

When you complete a chart, it appears on your spreadsheet. You can move the chart by clicking on the chart, holding the click and moving the mouse.

You can also change your chart, even after it is done. Select your chart, click on the Change Chart Type and select a different chart format.

Some things you can do with charts - you can select only the data you want to display by holding the control key down and dragging through the information you want to show AND you can change the colors in the chart by double clicking on any part of the chart and following the dialog box. TIP: try the fill effects.

TIP: the chart you chose MUST display the information (data) in a meaningful way so everyone understands the data immediately! You will find that most companies use bar charts and not pie charts.

AGAIN, charts are easy. Select the data, click on the Insert tab, and select a Chart Type.

You may need to size your chart. To do so, make sure the chart is selected (the handles will be displayed). Click the drag the handles to size.

To move a chart; move the point to the chart, until it turns into a 4-sided arrow. Click and drag to its new location.

To add a title:

• select the chart
• use Chart Tools, Design tab (if not displayed)
• click on one of the choices under Chart Layouts (scroll for more choices)
• click on the Chart Title to display teh handles. Enter your title and then press the Enter key

Excel's chart feature has a number of ways to change the look of the chart. Go to Chart Tools, Layout tab and experiment with all the other options.

email me for the assignments. I know the database and quiz are next.