How do I create Multiple Series in a Bubble Chart?

K

Kojones

I have searched the internet high and low, but none of the answers are easy
to follow. Please make it easy to follow with detailed instructions.

I need to make a bubble chart with 4 different series. I have laid the data
out in 4 groupings of 3 columns each, 1 grouping per series. I try to create
a bubble chart, then in the wizard under the Series tab, I define the 3
series very specifically. But when the chart displays, it is pulling the row
number as the X-axis value. How do I change it to pull the value from the
cell, and not the row number?

Thank you.
 
J

Jon Peltier

If your X data are not numeric, Excel replaces them with 1, 2, 3 in the
chart.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables. 0
Create a chart from a table in word thats dynamic 0
very odd bubble chart problem 3
Plotting multiple data series in a bubble chart 1
Gantt chart duration not showing 0
Bubble chart with multiple values per series 2
Bubble chart question 2
Making a Bubble Chart with 4 variables instead of 3 1

Top