Adding a Second Series
It's frequently useful to add a second series to the chart, allowing easier visual comparisons. Controls are available for this:
When the chart type (Bar, Line, Curved Line, Scatter Plot) supports it, the (1) Additional Column control will be available for you to use in selecting the Data Column for a second series. The second series (2) Aggregation and (3) Chart Type can be selected to suit your needs. A second axis and label will appear automatically along the side of the chart opposite the original Y-axis, as shown above. New for 14.2 You can also choose whether to show the value for the Additional Column on the chart by selecting Value from the drop-down list, shown below:
Below is an example of an additional series with its value shown on the chart for comparison: