cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
Liranlev
Level II

building a graph

I am trying to do something but can't find a solution.

I have 6 columns: A_0, A_1, B_0, B_1, C_0, and C_1. Each column contains multiple values. I want to create a graph with 4 linear lines.

  • All values from A_0 and A_1 should be on the same x-axis.
  • All values from B_0, B_1, C_0, and C_1 should be on the y-axis.

Why 4 linear lines?

  1. A_0 with B_0 (first line)
  2. A_0 with C_0 (second line)
  3. A_1 with B_1 (third line)
  4. A_1 with C_1 (fourth line)

Do you have any suggestions on how to do this?

2 REPLIES 2
jthi
Super User

Re: building a graph

Add your columns to your graph builder

jthi_0-1726671161708.png

Add four lines (right click add line).

Modify Variables of each line as needed

jthi_1-1726671241797.png

And depending on your data there might be other/better ways of doing this

-Jarmo
WebDesignesCrow
Super User

Re: building a graph

Hi @Liranlev ,

 

Based on what I understand, you would like to create;

- Line Chart 

- Expected Result: You want to have 4 linear lines only.

- X-axis variable: A_0 & A_1

- Y-axis variable: B_0, B_1, C_0 & C_1

 

Questions:

- Do you want a 4 linear lines per X-axis Category?

- Do you want a stack Y-axis? I'm not sure if the value within the same?

Or

- Do you want an overlay Y-axis?

 

*Many ways to create through Graph Builder. How do you want to see it ?

1) Stack Y-Axis

WebDesignesCrow_1-1726732625962.png

2) Overlay Y-axis

WebDesignesCrow_2-1726732833094.png

3) Stack Y-axis (mute the color of unwanted lines)

WebDesignesCrow_3-1726733063211.png

 

Anyway, you need to tick "Row order" to display all raw Y-values

If you can draft the visual of the output, it is much easier to help.