Microsoft Office Tutorials and References
In Depth Information
Chapter 4. Create Figures that Use
Both Charts and Worksheets
The spreadsheet itself offers significant power to enhance a chart.
In fact, most of the dashboard “look” and sophistication come from
spreadsheets that the charts are on.
This chapter discusses a variety of ways to use both charts and
worksheets in your dashboard displays.
Most of a dashboard’s appearance comes from spreadsheets, not
from charts. Two figures illustrate this point.
Chart Formatting with Spreadsheet Cells
Consider these four cells from a
dashboard report. They work together to
create a professional-looking figure.
Net Profit Margin
Cells K6, K7, and K9 contain formulas that
return the text shown. The dark green and
the light brown background colors are cell
patterns I assigned using the Patterns tab
in the Format Cells dialog.
% of Revenues
Except for the plot area, the chart is transparent. To set
transparency, select the Chart Area; choose Format, Selected
Chart Area; and then, in the Patterns tab, choose None for both the
Area and Border settings. If necessary, also select the plot area
and set a background color.
The chart is anchored in the range K7:K9. To anchor the chart, click
and drag it while holding down the Alt key. Drag the top-left corner
to the top-left corner of cell K7. Similarly, anchor the bottom-right
corner of the chart to the bottom-right corner of cell K9.