2 charts in one

[#1]

Hi, Can we have 2 or multiple plotting of different data on one chart with different scale or unit.

Just like the one in the attachment?

Thanks,

Laxm

[matt_crowther · Accepted solution]

Laxm,

Simple answer; yes you can.

Firstly create a 'Combo Chart' via the Chart Wizard. Create your expressions (2 bar 1 line) on the Axes tab of the Chart Properties slect the line expression from the Expressions list then switch the 'Position' radio button to be 'Right (Top)' this should then place the relevant axis on the right.

It's then a good idea to use 'Text in Chart' under the Presentation tab to correctly annotate your new axis.

Hope that helps,

Matt - Visual Analytics Ltd