Description

This course walks you through setting up Excel charts so they update automatically as data in entered into the worksheet. In addition, to discussing self-expanding charts, it also covers how to specify the number of data points to display in a chart. For example, you may only want the last rolling six months of data to display, in the chart, as you add new data each month. Linking a chart title to a cell and creating a spinner control is also discussed. This course walks you through the process step by step and then includes practice exercise for each topic as well as answer files.

• This EBook covers:
• Creating Range Names in a SERIES formula.
• Using OFFSET and COUNTA functions for charting purposes.
• Discusses other COUNT functions.
• Shows how to create Self-Expanding Charts.
• Shows how to displaying the last x number of data points.
• Selecting a beginning and ending point for a data series.
• Creating and using Spinners.
• Linking a Chart Title to a Cell.

Review Questions and Final Exam are completed under section “Review and Test”.