XL98: How to Change the Taper Style for All Series in a Chart (185306)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q185306 SUMMARY
Microsoft Excel 98 includes many new built-in chart types, including cone
and pyramid charts. By default, these chart types contain cones or pyramids
that taper to a point for each data point in a series; the height for each
cone or pyramid is equal to the value of the data point.
You can change the shape of the cones or pyramids for a series so that it
tapers to the value of the largest data point in all the chart series. With
this shape, all cones or pyramids for the series are the same, but they are
truncated according to the values of the data points. Note that you cannot
manually change the cones or pyramids for all of the series in a chart at
one time. You must change the shape of the cones or pyramids for each
series separately (one series at a time). To change the cones or pyramids
for all the series at one time, you must use a Visual Basic for
Applications macro.
This article contains a sample macro that modifies all the series in a
chart to the same shape.
REFERENCES
For more information about cone and pyramid charts, click Contents And
Index on the Help menu (or on the Balloon Help menu if you are using a
version of the Macintosh operating system earlier than 8.0), click the
Index button in Microsoft Excel Help, type the following text
and then click Show Topics. Select the "Examples of chart
types (cone, cylinder, and pyramid)" topic, and click Go To. If you are
unable to find the information you need, ask the Office Assistant.
For more information about the BarShape Property, click the Office
Assistant in the Visual Basic Editor, type barshape, click Search, and
then click to view "BarShape Property."
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If Microsoft Help is not installed on your computer,
please see the following article in the Microsoft Knowledge Base:
179216 OFF98: How to Use the Microsoft Office Installer Program
Modification Type: | Major | Last Reviewed: | 6/17/2005 |
---|
Keywords: | kbdtacode kbhowto kbProgramming KB185306 |
---|
|