Monday, November 17, 2008

Tip #13: Excel: Charts

Microsoft Office 2007 has removed the chart wizard feature. Charts are now created by a single click on the Office Ribbon’s Insert tab. This new charting feature allows easier customization. Once the chart is created you can modify it to display additional information and data.

Creating a Basic Chart
1. Arrange the data in rows and columns on a worksheet. Excel will determine the best way to plot the data. If you prefer a certain layout, look at the
suggested data arrangements provided by Microsoft Office.
2. Select the cells that contain the data for the chart.
3. On the Insert tab, in the Charts group click the chart type, and then click the chart subtype.
NOTE: To see all available chart type, click one chart type, and then click All Chart Types.
4. The chart will be placed in the worksheet as an embedded chart.


Moving the chart to a separate sheet
To place the chart in a separate sheet so that it can be viewed by itself:
1. Click the chart to select it.
2. On the Design tab, in the location group, click Move Chart.
3. Choose where you want to place the chart.


Changing the chart layout or style
Pre-defined chart layouts and styles allow you to instantly change the look of a chart. Chart layouts allow you to change the information displayed and how the information is positioned on the chart. Chart styles allow you to change the chart color and design.


Applying a predefined chart layout
1. Click the chart.
2. On the Design tab, in the Charts Layout Group, click the chart layout you want to use.
Applying a predefined chart style:
1. Click the chart.
2. On the Design tab, in the Chart Styles Group, click the chart style you want to use.
Many more options are available for chart formatting and customization. See
Microsoft Office’s Chart Creation for thorough directions on all charting options.

Where can I find more information about Office 2007? The ISS Training site provides Quick Reference Guides and Courseware for Microsoft Office. https://portal.twu.edu/iss-training/appstraining/ms_applications.htm
For additional support, please contact the Help Desk, (940) 898-3971.

No comments: