Worksheet Charts
Home Up Excel Basics Changing Worksheet Appearance Organizing the Worksheet Worksheet Formulas Function Formulas Making the Worksheet Useful Working with Multiple Worksheets Worksheet Charts Other Links

 

Student Objectives: Identify the purpose of charting worksheet data.; Identify the types of worksheet charts.; Create a chart sheet and save a chart.; Switch between charts and worksheets, zoom, and rename a chart., Preview and print a chart., Create an embedded chart.; Edit a chart and change the type of chart.

What is a chart or graph?
1) A chart is a graphical representation of data contained a worksheet.
2) Charts make the data of a worksheet easier to understand.
3) How do I do it? Highlight data on the worksheet for the chart, then either choose Insert, Chart OR the Chart button from the toolbar.

What are the type of charts/graphs?
1) Column charts: uses bars of varying heights to illustrate values in a worksheet and is useful for showing relationships among categories of data.
2) Line charts: Similar to the column chart except columns are replaced by points connects by a line.
3) Pie Charts:  Show the relationship of a part to a whole.
4) Scatter Charts:  Sometimes called XY charts, show the relationship between 2 categories of data.

What are the 2 ways to display charts?
1) By placing the chart on a chart sheet. A chart sheet is a separate sheet in the workbook on which you can create and store a chart.
2) By embedding the chart in a worksheet.  An embedded chart is created within the worksheet.  It's advantage is that it may be viewed at the same time as the data is created.

What is the Chart Wizard?
1 An onscreen guide that helps you prepare a chart. 
2) The Chart Wizard helps guides you in selecting the Chart Type; Chart Source Data; Chart Options; and Chart Location (chart sheet or embedded chart)
3)  How do I use it?  Choose Insert, Chart and the Wizard appears.

What are the various types of Chart Options?
1) Titles:  Headings that identify the contents of the chart or the axes.
2) Axes:  Lines that establish a relationship between data in a chart.
3) Gridlines:  Lines through a chart that relate the data in a chart to the axes.
4) Legend:  List that identifies patterns or symbols used in a chart.
5) Data Labels:  Text or numbers that identify the values depicted by the chart objects directly on the chart.
6) Data Table:  Data series values displayed in a grid below the chart.

How is data updated in a chart/graph?
1) Excel data in a chart/graph is automatically updated in a chart/graph when the worksheet values are changed.

How does a user rename a chart/graph?
1) Choose the sheet Format, Sheet, then Rename.
2) You may also change the name of the sheet by right-clicking the sheet tab and then clicking Rename on the shortcut menu.

How is a worksheet or chart sheet enlarged?
1) By using the Zoom Command
2) How do I do it?  Choose View, Zoom OR the Zoom box button on the toolbar.

What is a 3 dimensional chart?
1) Allows you to make charts look as though they were 3 dimensional
2) These charts can be 3 dimensional:  area, bar, column, cone, cylinder, line, surface, pie, and pyramid.

How are charts edited?
1) Clicking with the left mouse button selects the chart part for editing. (Ex. title, legend, etc.).
2) Double-clicking the left mouse button produces the dialog boxes for the parts selected.  These boxes let you change various options via tabs.
3) Clicking the right mouse button produces a short-cut menu such as clearing data, inserting data, or changing chart types.