2 lines & 1 bar chart

verytiredgirl

There's a group bar chart that allow you to have 2 bars and 1 line for each x value:

But is it possible to show 2 bars as lines and the 1 line as bar instead?

MichelleH

@verytiredgirl Yes, you can specify how many lines to display under Chart properties > General > Series on left scale. The value entered here dictates how many lines to display. For example, if you enter "2" then the first two measures in analyzer (the Y-Axis value plus the first Series value) will both be displayed as lines.