Microsoft KB Archive/273657

= XL2000: 3-D Column Chart Doesn't Appear As Full As Expected =

Article ID: 273657

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q273657



SYMPTOMS
When you create a 3-D chart in Microsoft Excel, the finished chart may not look as thick or as full as you expect it to; that is, your chart may not look like the 3-D chart example shown in Excel Help. The purpose of this article is to demonstrate how to generate 3-D chart effects similar to the example in the &quot;Examples of chart types&quot; Help topic.



CAUSE
This behavior can occur because automatic scaling can cause some of the chart labels to be hidden. This is especially true when there are a large number of series. Even with a low number of series, some chart labels may be hidden. In the following example, the region names are the most obvious items that may be hidden.



RESOLUTION
To generate a new 3-D Column chart, and then modify the default options to make the chart look like you want, follow these steps:  Start Excel and create a new workbook.  Create the following worksheet: A1:      B1: Europe   C1: S. America    D1: Far East A2: Q1   B2: 50       C2: 55            D2: 80 A3: Q2   B3: 60       C3: 50            D3: 75 A4: Q3   B4: 55       C4: 75            D4: 65 A5: Q4   B5: 70       C5: 60            D5: 70  Select cell A2. Click Chart Wizard on the standard toolbar. In the Chart type list, click Column. In the Chart sub-type list, click 3-D Column, (the last choice in the first column).</li> Click Next three times.</li> Click As new sheet, and then click Finish.</li> Right-click the the Y-axis (Series Axis).</li> Click Format Axis on the shortcut menu.</li> On the Scale tab, ensure that Number of series between tick marks is set to 1, and then click OK.</li> Right-click the plot area (the white area around the chart).</li> Click 3-D View on the shortcut menu.</li> In the Rotation box, type 40, and then click Apply.

Note the change to the view.</li> In the Elevation box, type 20, and then click Apply.</li> In the Perspective box, type 50, and then click Apply.</li> Continue to modify the Elevation, Rotation, and Perspective settings until you achieve the appearance that you want, and then click OK.NOTE: To view the results of any modifications, click Apply.</li></ol>

<div class="references_section">