Creating a table in Excel

[koertkopbeen]

Hi, guys

I'm looking to create a table in Excel with the same y-axis, but with two different variables compared on the x. Like this:



Any idea on how to enter this data into a spreadsheet for the table to come out like this?

Kindly,

KK

 

[agentrfr]

Hey my dude

I got you covered

 

[agentrfr]

Um I think it is easier the other way round tho, thats just me

 

[koertkopbeen]

Hi, thanks for this. Can I ask how you did this? Did you use an Excel sheet? If so, how did you organise the data set?

 

[agentrfr]

I'm just messing with you

Check your PM I will send you a link to the excel document. All you need to do is add multiple data sets to a single chart, then format them together