5.00 5.00c 7.00 | 5.00 5.00a
WINDOWS | MACINTOSH
kbusage
The information in this article applies to:
- Microsoft Excel for Windows, versions 5.0, 5.0c
- Microsoft Excel for the Macintosh, versions 5.0, 5.0a
- Microsoft Excel for Windows NT, version 5.0
- Microsoft Excel for Windows 95, version 7.0
SUMMARY
In Microsoft Excel, you can add a vertical line to a chart such that the
line has a mathematical relationship to the data on your chart. You can
use this line to show the dividing point between historical data and
projected data.
To create this line, follow the procedure in the "More Information"
section of this article.
NOTE: This feature is not available in earlier versions of Microsoft Excel
5.0.
MORE INFORMATION
- Enter the following sample data in a new Microsoft Excel worksheet.
Sample Data
-----------
A1: a B1: 1
A2: B B2: 2
A3: c B3: 3
A4: d B4: 4
A5: e B5: 5
A6: 1.5 B6: =CEILING(MAX(B1:B5),1)
A7: 1.5 B7: =IF((MIN(B1:B5)>0)*(MIN(B1:B5)<=1),0,MIN(B1:B5))
NOTE: The formula in cell B6 sets the maximum to the round up value of
the maximum of your data. The formula in cell B7 will set the minimum
value of the vertical line equal to zero if the minimum value of your
data series (B1:B5) is less than or equal to 1 and greater than 0.
- Select cells A1:B5, and choose the ChartWizard tool.
- With the ChartWizard tool active, select a location for the chart, and
then choose Finish.
- Select cells A6:B7, and choose Copy from the Edit menu.
- Select the chart object, and choose Paste Special from the Edit menu.
- In the Paste Special dialog box, select the following options
- Under Add Cells As, select New Series
- Under Values (Y), select Columns
and select the "Categories (X Labels) In First Column" check box.
- Activate the Chart Object, select the new column, and choose Chart Type
from the Format menu. In the Chart Type dialog box, select the following
options and choose OK:
- Under Apply to, select Selected Series
- Select the XY (Scatter) chart type
- With the new series selected, choose Selected Data Series from the
Format menu, select the Patterns tab, and select the following options:
- Under line, select Custom
- Under Marker, select None
To adjust where the line is plotted, change the numbers in cells A6:A7.
|