Creating Interactive and Dynamic Charts (HTMC)

Pre-requistes:

You must be able to create and edit a simple chart. Familiarity with basic functions and absolute cell references is strongly recommended.

Knowledge Level:

Intermediate

Major Topics:

• 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

Learning Objectives:

• Differentiate between different types of cell references and recognize to apply them 
• Recognize the steps needed to create the components of range names and named formulas 
• Differentiate between the different COUNT functions 
• Recognize how to use the SERIES, OFFSET and COUNTA functions to create dynamic charts that update automatically 
• Recognize the concept of input cells and how to apply them 
• Recognize the steps needed to link a chart title to a cell so that a chart title updates automatically 
• Recognize the steps needed to create a spinner or scroll box

Designed For:

All CPAs