Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
XL97: How to Change the Taper Style for All Series in a Chart
Article ID: 162092 - View products that this article applies to.
This article was previously published under Q162092
Microsoft Excel 97 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 of 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 provides an example macro that modifies all the series in a chart to the same shape.
Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs.
If you have limited programming experience, you may want to contact a Microsoft Certified Partner or Microsoft Advisory Services. For more information, visit these Microsoft Web sites:
Microsoft Certified Partners - https://partner.microsoft.com/global/30000104
Microsoft Advisory Services - http://support.microsoft.com/gp/advisoryservice
For more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site:http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS
Creating the Sample ChartBefore you use the sample macro, create a chart to modify. To do this, use the following steps:
NOTE: The cones for each data point taper to a point.
Sample Macro for Changing Cone Shapes
For more information about cone and pyramid charts, click the Index tab in Microsoft Excel Help, type the following text
coneand then double-click the selected text to go to the "Examples of chart types (cone, cylinder, and pyramid)" topic.
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 Excel Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/120802/EN-US/ )Office: How to Add/Remove a Single Office Program or Component
Article ID: 162092 - Last Review: November 23, 2006 - Revision: 2.4