Plot different y-values in the same chart
The category group and series group expressions define the basic set of data. However, you can provide multiple expressions as y-values and thus plot different y-values for the same data.
In the Chart Properties, select the Data page.
Under Category Group, select the category group expression.
If required, select a series group expression under Series Group.
As multiple y-values are displayed the same way as multiple series values, using both options at the same time may lead to an overcrowded chart.
Under Data Values/Select Y-Value, select the required data fields and click
to
move them to the active settings.If required: Under Data Values/Select X-Value, select the same number of data fields as for the y-value. You can select the same x-value expression multiple times. X-values are only available for Scatter and Bubble charts.
If required: Under Data Values/Select Size, select the same number of size expressions as for the y-value. You can select the same size expression multiple times. Size expressions are only available for Bubble charts.
Save the settings.