Microsoft Office Tutorials and References
In Depth Information
Take care when you adjust the Plot Area within the Chart Area,
because all your other charts of this type will use the same
Step 5: Set Up Data for Other Charts.
To set up the data for the other charts, copy the first data sheet,
sheet A. Name these new sheets B, C, D, etc. Then change their
data and formulas as needed to display the other data.
To illustrate, the FigTitle
for sheet B (shown in
column D) would be
Gross Margin. The
ScaleType would be 5.
The UnitsLabel would
have a formula of…
…and it would return “Percent” as shown.
You might find it easier to set up sheet B, and its chart; then set up
sheet C, and its chart; and so on. Either method works.
Step 6: Set Up the Other Chart Figures.
To set up the second chart figure, copy the range B4:B6 to cell D4,
as shown in the figure above. This action will copy both formulas
and the chart. Then connect the formulas and the chart to the data
sheet for the second chart.
Connecting the formulas is easy to do. You merely change a
formula like =A!FigTitle to =B!FigTitle. And you change SERIES
formulas from something like =SERIES(,A!Month,A!Actual,1) to