How To... Draw a Basic Scatter Diagram in Excel 2010

A Scatter Diagram helps show if there is a relationship between two variables. In this video you will learn how to draw a basic scatter diagram using two sets of data.

[shellac]

Thanks for the great video!  Greetings from the Clemson MBA program in Greenville, SC USA

[angelpriegoquijano]

Thank you again already subscribed and gonna recommend to my co workers and class mates :) really awesome channel

[ThatTubaGuy]

Yay, thank you Dr. Eugene! Greetings from Singapore~ Very clear presentation :) This helps me a lot since its all about independent learning nowadays and this is really convenient! Double Thumbs UP!.... :)

[eoloughlin]

Hi Nathan,

Greetings to you, and all Canadians - thank you for your kind comment.

I am Irish, born in Co Wicklow and living in Dublin City.

Best,

Dr E.

[EugeneOLoughlin]

Hi angelpriegoquijano. There's a few ways you can do this: First, you can simply make the graph larger by just dragging the corners until you get a big enough size. You could also just make the graph taller, in my example you could drag the bottom of the box that the graph is in to the bottom of your screen. Another way is to right click on the axis for your data, select "Format Axis" and in "Axis options" you can decrease the scale (max/Min) of your axis - this will spread it out a bit more. E.

[EugeneOLoughlin]

Hi Jacqueline,

In the Chart Tools ribbon, select the Layout tab and "Axis Titles".

Hope this helps,

Dr E.

[angelpriegoquijano]

ty very much this video as many other in your channel have been extremely helpful
i do have a question i hope u can help me with

is there a way to "enlarge" or zoom in if the dispersion its concentrated as in u cant really see the space between most of the dots?

[moondragon]

great video. just curious, are you irish or scottish? i am just wondering what kind of accent that is.

[mushtaqahmad]

Nice to kill two birds with one stone.