montrof
asked on
Bubble Chart or Scatter Plot
I am trying to create a graph that would show revenue on the x axis and time spent on the Y axis and then the dots would grow in size based on revenue and I also want the color of the dot to change based on satisfaction level rating. Here is the some sample date
Customer Revenue time Hr satisfaction
Cust A 25000 10 5
Cust B 17500 5.5 3
Cust C 7000 8 2
Cust D 12000 9 4
The dot would be red if it was 1 or 2, Yellow if it was 3 and Green if it is 4 or 5.
Thanks,
Montrof
Customer Revenue time Hr satisfaction
Cust A 25000 10 5
Cust B 17500 5.5 3
Cust C 7000 8 2
Cust D 12000 9 4
The dot would be red if it was 1 or 2, Yellow if it was 3 and Green if it is 4 or 5.
Thanks,
Montrof
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is it possible to use names on the Category axis?
To my knowledge, a bubble chart is like an X-Y scatter chart, and only values can be used for X, Y and bubble size.
To my knowledge, a bubble chart is like an X-Y scatter chart, and only values can be used for X, Y and bubble size.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Smart solution to make a line chart look like a bubble chart.
I save it for future use.
I save it for future use.
It would be much more normal to put the Customer names on the Category axis, with Time on the Y-axis, Revenue for bubble size and color for satisfaction.
If you don't care about customer names, then you could put Revenue on the X-axis, Time on the Y-axis and Satisfaction as bubble size.