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.

My data rows look as follows: enter image description here

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.

What I would like the diagram to look like: enter image description here

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:

enter image description here

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.

- Tobbe

migrated from stackoverflow.com Nov 19 '18 at 23:03

This question came from our site for professional and enthusiast programmers.


You can do it with the help of two helper rows, each filled with the same number:

enter image description here

You then right click on the chart and select Select Data and choose Edit:

enter image description here

For the Y value of each series, enter the corresponding helper row:

enter image description here

Your chart should now look like this:

enter image description here

  • Thank you very much for your answer. It worked really well. I sometimes forget to create helper data for creating the diagram and not just for the raw data itself. – Tobbe Widner Nov 19 '18 at 21:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.