Two data sets on one visualisation

[JWorthy]

Hello,

I'm trying to present two data sets on the same visualisation in quite a simple way - I just can't work out what I'm doing wrong!

I've had a competition and I want to show how prizes allocation compares to competition entries by region in the UK.

The two seperate data set visualisations are below. How can I combine them?

These are the two data sets I'm trying to combine. The left visualisation is the number of prizes awarded by region in UK. The right hand one is number of competition entries by region of the UKWhen I try and present the data on the same graph the counting breaks - why?

Thanks!

[jthomson · Accepted solution]

You might need to create a table that has your list of regions, then relate it to your two data sets and put that as your axis

[JWorthy]

Thanks! I had to standardise some of the region names between the two data sets as well.