Create Dynamic and Interactive Charts (Text Based Course)

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”.