I'm working on a report in which I want to create a bubble diagram, which represents the ocurrances of genders male and female corresponding to a specific age, but I'm struggling with editing the data view, so it displays the results as I want them.
The numbers following the labels "Male" and "Female" represent the number of ocurrances of the specific gender corresponding to the given age in the first row.
And this is the current diagram I could create for now, but even after trying to align the data according to how I understand, how diagrams work in excel, I still can't assign the data on the correct axis:
Is it even possible in excel to create a bubble diagram the way I want to? Thank you very much for your answers in advance.