Microsoft Office Tutorials and References
In Depth Information
Chapter 7: Creating Interactive Charts
Chapter 7
Creating Interactive Charts
IN THIS CHAPTER
Introducing the concept of interactive charts
Creating a self-expanding chart — a chart that updates automatically when
data is added or deleted
Using a scrollbar to specify the data in a series
Using a drop-down list to choose a beginning point and an end point for
a series
Plotting the last n data points in a series
Plotting every nth data point in a series
Plotting a series based on the active cell
Using a check box or a drop-down list to select a series to plot
T HE TERM INTERACTIVE CHART , as used in this topic, refers to a chart that changes
automatically, based on the worksheet environment. In a sense, all charts are
interactive because charts series are linked to ranges, and the chart updates
automatically when the data is changed. This is not the type of interactivity covered in this
chapter.
Introducing Interactive Charts
If you create spreadsheets that are used by others, you’ll probably find several useful
techniques in this chapter. Many of these examples have a single goal: to make it
easier for users (especially novice users) to deal with a workbook that contains charts.
A few examples of interactive charts include:
A chart that updates itself to use newly added data
A chart that updates itself when data is deleted
A chart that limits the amount of data displayed in a series (for example,
the last 12 data points)
209
Search JabSto ::




Custom Search