Layout Tab (Chart Options)
Use the Layout tab to change the chart type, select a dual-axes chart, and apply or remove 2.5D depth effect to the chart risers and frame.
The descriptions in this section apply to all chart types except Bubble, Histogram, Pie or Doughnut, Scatter, Surface, and Stock.
- Type
- Select a radio button to change the chart type. See Chart Types for overview of the main chart types and their most common uses.
- Dual Axes
- Select this check box to make the area chart have two numeric axes (Y1 and Y2). This option is only available for clustered and stacked area charts. It is not available for Percent and True 3D charts.
- Split Dual Axes
- When the Dual Axes check box is selected, half of the series in the chart are assigned to the primary numeric axis (Y1) and the other half to the secondary numeric axis (Y2). However, all risers are drawn from a single category axis base line. The series assigned to the Y1 and Y2 axes are drawn on opposite sides of the chart. If you want to physically split the chart and show two separate numeric axes, select this check box. If the Dual axes check box is not selected, this check box will be grayed out.
Funnel Charts
- 2D Funnel
- Select this check box if you want a flat effect applied to the funnel. Do not select this check box if you want a 3D chart.
Bubble Charts
The chart layout options for a bubble chart can be used to select a dual-axes chart.
- Dual Axes
- Select this check box to make the Bubble Chart have two numeric axes (Y1 and Y2).
Histogram Charts
The chart layout options for a histogram chart can be used to select a vertical or horizontal histogram.
- Type
- To change the chart layout, select one of these radio buttons Vertical Column or Horizontal Bar.
Pie or Doughnut Charts
- Type
- To change the chart layout, select one of these radio buttons Pie or Ring Pie.
- Pie Size Proportional to Total
- Use this check box to make the size of the each pie chart proportional to the total values in your data. This option is only used for multiple pie charts. When your data includes more than one group/column, a pie chart is drawn for each category. Selecting this option will draw each pie proportional to the total that each pie represents.
- 2D Circular Pie
- By default, all 2D-charts are presented with a 3D-depth effect applied to the chart frame. Select this check box if you do not want this 3D-depth applied.
Scatter Charts
- Dual Axes
- Select this check box to make the Scatter Chart have two numeric axes (Y1 and Y2).
Stock Charts
- Style
- To change the riser style, select either Wall Street or Candle.
- Layout
- To change the detail of the data shown by the risers, choose High Low, High Low Open, High Low Close, or Open High Low Close.
Note The option you choose in the Layout area depends on the data available for your stock chart. For example, to use High Low Open, your data must include values for an opening price.
3D Surface Charts
- Type
- To change the chart layout, select one of these radio buttons Surface, Surface with Sides, or Honeycombed Surface.
See Also
Dual Y Options Tab | Chart Options Dialog Box