Microsoft Excel 2007 - Illustrated

1. Microsoft Excel 2007 -Illustrated Enhancing Charts

2. Customize a data series Change a data source and add data labels Format the axes of a chart Add a data table to a chart Objectives Microsoft Office Excel 2007 - Illustrated

3. Rotate a chart Enhance a chart with WordArt Add a picture to a chart Identify data trends Objectives Microsoft Office Excel 2007 - Illustrated

4. Customizing a Data Series A data series is the information, usually numbers or values, that Excel plots on a chart Microsoft Office Excel 2007 - Illustrated

5. Changing a Data Source and Adding Data Labels Descriptive text, called a data label, appears above a data marker in a chart Microsoft Office Excel 2007 - Illustrated

6. Changing a Data Source and Adding Data Labels (cont.) Data label Microsoft Office Excel 2007 - Illustrated

7. Formatting the Axes of a Chart Excel plots and formats chart data and places the chart axes within the chart’s plot area Data values in two-dimensional charts are plotted on the y-axis and categories are plotted on the x-axis A scale is created for the value (y) axis that is based on the highest and lowest values in the data series Microsoft Office Excel 2007 - Illustrated

8. Formatting the Axes of a Chart (cont.) Three axes are generated in three- dimensional charts; x-axis (category), z-axis (value), and y-axis (chart depth) Z-axis usually contains the scale for the chart Override Excel default formats for chart axes using the Format Axis dialog box Microsoft Office Excel 2007 - Illustrated

9. Formatting the Axes of a Chart (cont.) Value (z) axis Maximum value Minimum value Microsoft Office Excel 2007 - Illustrated

10. Adding a Data Table to a Chart A data table is a grid containing the chart data, attached to the bottom of a chart Data tables are useful because they highlight the data you used to generate the chart Microsoft Office Excel 2007 - Illustrated

11. Adding a Data Table to a Chart (cont.) Data table Microsoft Office Excel 2007 - Illustrated

12. Rotating a Chart By rotating a 3-D chart, you can improve the visibility of the chart data Depth can be increased to improve visibility of chart data Microsoft Office Excel 2007 - Illustrated

13. Rotating a Chart (cont.) Increased depth and rotation Microsoft Office Excel 2007 - Illustrated

14. Enhancing a Chart with WordArt Enhance a chart or worksheet by adding specially formatted text Format WordArt using 3-D effects and shadows WordArt text is considered an object Microsoft Office Excel 2007 - Illustrated

15. Enhancing a Chart with WordArt (cont.) WordArt text Microsoft Office Excel 2007 - Illustrated

16. Adding a Picture to a Chart Enhance a chart by adding a picture to the data markers, chart area, plot area, legend, or chart walls and floors Microsoft Office Excel 2007 - Illustrated

17. Adding a Picture to a Chart (cont.) Picture added to the back wall Microsoft Office Excel 2007 - Illustrated

18. Identifying Data Trends Creating a trendline Trendlines graphically represent data trends Emphasize patters in data Predict future data based on past trends Microsoft Office Excel 2007 - Illustrated

19. Identifying Data Trends (cont.) U.S. Trendline U.K. Trendline Microsoft Office Excel 2007 - Illustrated

20. Summary Customize data series Format chart axes and add data tables Rotate a chart Use WordArt to enhance charts Add pictures to charts Identify data trends Microsoft Office Excel 2007 - Illustrated