Microsoft Office Tutorials and References
In Depth Information
Step 4: Create the First Mini-Chart Figure.
Chapter 2 described how to create a mini-chart. Chapter 3
described ways to format charts. Chapter 4 described how to create
a worksheet figure that uses the mini-chart object. In this step, we
apply those techniques.
This figure shows the first dashboard chart
in the dashboard worksheet. The chart
object is anchored in cells B4 and B6.
The line in this chart has the formula:
=SERIES(,A!Month,A!Actual,1)
And the area chart type has the formula:
=SERIES(,A!Month,A!Budget,2)
Two cells in this figure contain formulas.
B4: =A!FigTitle
Returns the title for the figure, as shown in cell B1 of Figure 8-5.
The cell is centered, and its font is Arial 8-point bold.
B6: =A!UnitsLabel
Returns the units label for the figure, as shown in cell B4 of Figure
8-5. The font is 6-point Arial.
After you first anchor the chart in the range, you probably will need
to adjust the Plot Area within the Chart Area. Click and drag the left
side of the Plot Area as far as possible to the left. Then drag the
right side of the Plot Area as far as possible to the right.
Drag the top of the Plot Area so that it’s slightly below the title. Drag
the bottom of the Plot Area so that its X-axis labels are above the
units label in row 6.
Search JabSto ::




Custom Search