Analysis Chart - 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.