9 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)