Second axes in line chart

[Anonymous]

Dear Colleagues, good day!

I have line chart with 2 expr. Is there any way to add second axes for second expr?

Example in attachment.

Many thanks.

[Gysbert_Wassenaar · Accepted solution]

You can choose to put the second expression on the secondary axis on the Axes tab. It's a bad idea because you'll create a confusing chart. It's better to use two charts for this. Can you tell which expression belongs on which axis if you only look at the chart?

[Mark_Little]

Hi,

I would have to agree with Gysbert, I would approach as two charts.

In the Axes tab highlight the expression > Tick split axes.

Mark

[Anonymous]

No, i can't tell at once dependence between expr and axes.

Now i'm trying to show second axes and it's display isn't practical.

Could you advice something for it please?

[Anonymous]

This is happening becoz of -ve values in expression..

Could you post sample data for same?

[Anonymous]

will this help you?

see the attachment..

[Gysbert_Wassenaar]

My advice is to use two separate line charts.

[vincent_ardiet]

Hi,

Uncheck the "Forced 0" option it will look nicer.

[anna_castan]

Thankss!!! 🙂