Line offset

[#1]

Hello all,

I am creating a bar/line chart where I am showing 3 things - product performance for this year (bar), product performance expectation (line) and product performance for same months last year(line). For the last one, as it's taking place in previous fiscal period, I need to place some sort of a line offset, that will show performance for respective months, but on top of the current year's performance for clearer visualisation. Do you know how to make that happen?

Thank you for your help,

Anna

[Anonymous]

Hello Anna,

You can use Offset propertie for an expression. In the chart properties, Expression tab, click on the plus button related to the expression and fill the expression for offset.

An other solution is to split axis. Axis tab, split option on the right.

Vincent