cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use to use Text Explorer to glean valuable information from text data at April 25 webinar.
Choose Language Hide Translation Bar
View Original Published Thread

building a graph

Liranlev
Level II

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.