Create a Dot Plot to Show Before and After

You can do a lot with X Y scatter charts...like creating a dot plot chart. This video show a simple way to create a dot plot chart to show a before and after scenario. You can also think of it as a chart to make a comparison of one item to another in a linear sort of a way. It's simple to create and easier to make sense of ; so stop plodding around and watch the video.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@alexrosen8762]

Wow! Really good chart if you want to compare one thing to another. Thanks Doug.

[@DougHExcel]

Glad you liked! I got this idea from a data viz guru Stephanie Evergreen, she's got some great examples.

[@judydooley2945]

This is exactly what I need. Thanks so much!!

[@DougHExcel]

Hi Judy Dooley...you're welcome, glad you liked!

[@TiMalice2009]

I always refer to your channel for presentation ideas!

[@DougHExcel]

Thanks!

[@rosababad7928]

Thank you so much! I always refer to you if need to design presentation for ideas. I have a question, need to design line chart but begining and end line might be in different format like dots or small separate lines - - -.
maybe you have already video with it?

[@DougHExcel]

You can have different marker on same line. See this video for insight ua-cam.com/video/Gc3cb6vsKQc/v-deo.html

[@rosababad7928]

Thank you, but I think need little different, something like this

[@wadieseruge3523]

Doug, hi. do you have a video that talks about how to set up log in screens for different users in excell? Dan

[@DougHExcel]

Not really a feature in excel for login, but file security may give you some insights. See ua-cam.com/video/JEPS3KOxpmU/v-deo.html

[@sosoboss]

Hi, thank you very much for the tutorial. I'm tyrying to create the same graph, but I'm comparing average price for product. So, i have a different value for my products and the plot are very close. So we don't see the connection. Do you have an idea to have a better result ? I can maybe sent you my work to show what I'm trying to explain ?

[@DougHExcel]

Maybe try panel charts
ua-cam.com/users/dough517search?query=panel

[@sosoboss]

Thank for your answer I think I'm going to reproduce a back to back chart, with in the left side the previous year and in the right side, the current year. So I can compare the average price for each product between two years. What do you think ?

[@DougHExcel]

That could work too...here's some examples
ua-cam.com/video/lVvQOdPr97E/v-deo.html
ua-cam.com/video/QIkdXcDsEno/v-deo.html
ua-cam.com/video/DbFU7Js8_h4/v-deo.html
ua-cam.com/video/SGr-uzAGrD4/v-deo.html

[@automationguide3498]

Thank You !!

[@DougHExcel]

You're welcome!

[@walidkhlil2872]

thanks

[@DougHExcel]

You're welcome!