Microsoft Office Tutorials and References
In Depth Information
Charts That Use a Single Data Point
10. The axis labels for the XY chart are next to their respective axis. You may
prefer to set the Tick mark labels option to Low, using the Patterns tab of
the Format Axis dialog box.
Another way to get a four-color background effect is to create an image file
that consists of four colored quadrants. Then you can use the Format Plot
Area dialog box to specify this file to be used as the Plot Area background.
Charts That Use a Single Data Point
The two examples in this chapter demonstrate how to display a single value in a
chart. This is done by using metaphors such as a thermometer, a speedometer, or a
tachometer.
Creating a thermometer chart
You’re probably familiar with a “thermometer” type display that shows the
percentage of a task that’s completed. Creating such a display in Excel is very easy. The
trick involves creating a chart that uses a single cell (which holds a percentage
value) as a data series.
Figure 8-8 shows a worksheet set up to track daily progress toward a goal: 1,000
new customers in a 15-day period. Cell B18 contains the goal value, and cell B19
contains a simple sum formula:
=SUM(B2:B16)
Cell B21 contains a formula that calculates the percent of goal:
=B19/B18
As you enter new data in column B, the formulas display the current results.
To create the chart, select cell B21, click the Chart Wizard button, and create a
column chart. Notice the blank row before cell B21. Without this blank row, Excel
uses the entire data block for the chart, not just the single cell. Because B21 is
isolated from the other data, the Chart Wizard uses only the single cell. Other changes
required are the following:
Remove the category (x) axis.
Remove the legend.
Add data labels.
Search JabSto ::




Custom Search