Use the options in the Data Configuration tab in the Chart Types and Configuration dialog to configure the data to appear on the 2nd y-axis.
![]() |
This only works with bar, line, and area charts only. When other chart types are selected, you may see different options under the Data Configuration tab when the chart types require specification of data values. |
The Data Configuration tab lists the dimensions that appear in the chart's legend. If you change the dimensions to be placed on the legend using options in the dialog's Axes Placement tab, click Apply to have the correct legend dimension members appear in the Data Configuration tab.
To combine chart types:
![]() |
If there are more than 28 dimension members on the chart legend, only the first 28 will appear in the Data Configuration tab. Use the Axes Placement tab to adjust which members are on the legend. |