6 Replies Latest reply on Mar 19, 2016 9:56 AM by Łukasz Majewski

# Line Charts, how to position a 2nd mark to a dual axis line

Hello,

Is there a way to position a 2nd mark on a dual axis next to the first mark? See attachment. For Cameron, you see a 2160 and a 0 ( underneath the 2160). Is there a way to put the 0 next to the 2160 instead of under it? I'm looking to space them apart because if the number ranges are small, those two numbers will overlap each other.

• ###### 1. Re: Line Charts, how to position a 2nd mark to a dual axis line

Yes, click 'Labels' in 'All' mark and then the highlighted dotted 'Text' edit field:

This is what you currently have - the 3 measures are separated by new line:

so you may simply delete those and put a space in between:

Cheers,

Łukasz

1 of 1 people found this helpful
• ###### 2. Re: Line Charts, how to position a 2nd mark to a dual axis line

Hi,

You can play with alignment of the labels from the marks card. Pls follow the below screen shot for better understanding.

e.g just assume you have bar char like this.

In the marks card edit label and put left alignment with some additional spaces.

In your dual axis put you another label with right alignment. like this

then synchronize the dual axis and here you have two labels

I hope this is what you are expecting

Mahfooj

1 of 1 people found this helpful
• ###### 3. Re: Line Charts, how to position a 2nd mark to a dual axis line

Thanks Lukasz!

For the top line SUM(Amount), is there a simple calculation to say" If SUM(Amount) > 1000, then "Green", Else "Red"? I've seen tricks and work arounds to color code numbers on a table, but I'm wondering if it's different on a line chart.

• ###### 4. Re: Line Charts, how to position a 2nd mark to a dual axis line

like this?

• ###### 5. Re: Line Charts, how to position a 2nd mark to a dual axis line

No, I mean the "0", next to the 2160 for Cameron and the rest of the people. I plan to convert the "0" to a % when I get more data, so green would be positive and red would be negative. I've seen how this is done in a table, but is there an easier way in a line chart?

• ###### 6. Re: Line Charts, how to position a 2nd mark to a dual axis line

I believe it is only feasible when the secondary axis is of Text type and not line: