Create Scatter plot

LeahKristine

New Member
Joined
Jul 12, 2012
Messages
1
I have a table I have complied with injuries listed by department, length of service time prior to injury. I am trying to create a scatter plot to reflect this information. I want it to show chart how long a person serviced prior to injury, but i also want to be able distinguish between departments.
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

bleuspam

New Member
Joined
Jul 12, 2012
Messages
5
So you'd like to plot the length of time in service by other metric, correct? What is the 2nd metric?

I would use x,y charts in Excel. Time in Service would be on the bottom axis, I'm not sure what you'd have listed for your other axis, and then the dots would represent injuries. You could add multiple series per department so that different departments were different colors.

Key things to remember:
-Sort your table by Dept (whatever you want your different series to be) - You'll have to manually add each set of x,y through click n drag
-The Excel wizard sucks with Scatter charts. Immediately after creating it via Insert-> Scatter... right click, edit series and delete the series that are there. Add your own manually.
-Excel doesn't let you label the dots. So if your colors were departments but you wanted a label for the employee's name, you can't do that without doing it manually. There's a free add-in that will automate that task, called XY Chart Labeler

There is a rather expensive but neat tool call Tableau that works well for this sort of visualization.

If you want to create complex combinations of a variety of factors on multiple scatterplots, the free statistics program R can do it. There's a huge learning curve and it's frustrating to pick up - but when you get it it's a big time saver if you have 10 variables which all need compared to each other (100 scatterplots!)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,842
Messages
5,598,396
Members
414,235
Latest member
sucosama

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top