How to create Parallel Coordinates in Excel?

Question

Hi, could someone share how do I create a parallel coordinates plot with the dataset below in excel?

	Conversions	CPA	CVR
Target	437.8	$34.33	1.96%
Feb	115.5	$71.82	1.08%

I tried to create one but I'm not sure how to add a vertical line to each of the variables (Conversions, CPA, CVR).

I would like to do something similar as the graph below.

Thanks in advance :)

Answer 1

1. Add Primary Major Vertical and Primary Minor Vertical.
2. Change the Primary Major Vertical color fill to white.
3. Set Primary Minor Vertical to Solid Line

Answer 2

Hi Snow, thanks for your help as always! How do I adjust the 'axis' for each of the Primary Minor Vertical line?

In the graph below, 'classes', 'hours studying' and 'assignments completed' have a max number of 25, 25 and 12 respectively, instead of 100 (for 'midterm grade' and 'final exam grade')

Answer 3

I guess the raw data is percentage.

Then use the Value from cells to show the numbers.

I choose the incorrect range for A and B line. so the data value shows incorrect.

Here is my data and formula.

Answer 4

Hi Snow, how does the above work with this dataset instead?

	Conversions	CPA	CVR
Target	438	$34.33	1.96%
Feb	116	$71.82	1.08%

Answer 5

Hi Snow, I guess you can ignore my qn above. Looks like it works. Thanks so much!