Creating a table in Excel

koertkopbeen

Well-Known Member
Joined
Jun 2, 2008
Messages
100
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:

726694

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

Kindly,

KK
 

agentrfr

Expert Member
Joined
Jul 8, 2008
Messages
4,746
Um I think it is easier the other way round tho, thats just me
got it bud 2.PNG
 

koertkopbeen

Well-Known Member
Joined
Jun 2, 2008
Messages
100
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

Expert Member
Joined
Jul 8, 2008
Messages
4,746
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
 
Top