Information for Spreadsheet Charts

Fran Wells, Tompkins Cortland Community College

15 Information for Spreadsheet Charts

Information for Spreadsheet Charts

Charts help express data in a table. Before creating a chart, consider the following:

1. Purpose of the chart – what information do you want to emphasize.

2. Results to display – which chart is appropriate.

3. Determine what data to illustrate in the chart – sometimes there is a need to select great quantity of data and other times just a small amount. Different chart types display in distinctive ways.

4. Understand of elements of a chart – (See 3-D cluster chart elements on page 2 for an explanation of terms for axis, legend, data labels, etc..)

Types of Charts

3D Cluster Chart – Chart Elements

Adjustable Chart Elements

(Found by clicking on Chart Tools, Design, Chart Layout Group)

License

Icon for the Creative Commons Attribution 4.0 International License

Introduction to Spreadsheets by Lumen Learning is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.