Excel - How To Put Multiple Data Sets On A Scatter Plot In Excel - Episode 1991 скачать в хорошем качестве

Excel - How To Put Multiple Data Sets On A Scatter Plot In Excel - Episode 1991

Microsoft Excel Tutorial: How To Put Multiple Data Sets On A Scatter Plot In Excel Welcome to MrExcel Episode 1991, where we will be discussing the 2-Series Scatter Chart in Excel. If you're new here, make sure to subscribe to our playlist by clicking the "i" on the top-right hand corner. I'm Bill Jelen and in this episode, we will be diving into the world of comparative scatter charts. In our previous episode, we talked about pacing new data on a chart. Today, we will be focusing on comparing two different populations using the paste trick. This is a great tool to use when the populations have a different number of members. We will be comparing years of experience with salary, specifically for those who own the MrExcel Excel book and those who don't. To start, we will create the chart for the first series by selecting Insert and choosing a Scatter Chart. Then, we will resize the chart to fit between the two populations. Next, we will add the second series to the chart by carefully selecting the new data, including the heading, and using the special version of Paste Special. This trick was taught to me by John Pelletier, the chart goofer who hikes LM VP(?). We will choose "Categories (X values) in First Columns" and click OK. Now, we have our second series on the chart, but it's important to differentiate between the two. We can do this by adding a legend and showing it at the top. The dark blue represents book owners and the light blue represents those without the book. We can even change the color of the series to make it easier to distinguish. You can continue to add more populations to the chart using this same method. Scatter charts are a unique type of chart that have an extra component that most other charts don't have. It can be tricky to create multiple series in the same chart, but with this paste trick, it becomes much easier. This is tip #10B, one of "The 40 Greatest" tips in our book. Don't forget to order your copy online by clicking the "i" on the top-right hand corner. Thank you for watching and we'll see you next time for another netcast from MrExcel! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-... Table of Contents: (00:00) 2-Series Scatter Chart (00:19) Using the paste trick to create a comparative scatter chart (00:30) Comparing two different populations using the paste trick (01:00) Adding a second series to the chart (01:30) Adding a legend to differentiate between series (01:46) Changing the color of the series (02:01) The unique components of scatter charts (02:11) Difficulty in creating multiple series in the same chart (02:21) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelhacks #excelscatterchart #charts #excelcharts #excelchartstutorial This video answers these common search terms: how to create a scatter graph in excel using 2 data sets How To Put Multiple Data Sets On A Scatter Plot In Excel how to plot multiple scatter plots in excel how do i make a scatter graph in excel how do i make a scatter plot in excel how to create a scatter plot in excel with 3 variables how to make multiple scatterplots at once in excel how to create scatterplot with multiple serioes excel how to get categorical scatter group in excel how to get categorical scatter group pn excel how to add color groups to scatterplot excel how to split excel data into two groups in a scatter graph how to create an xy scatter plot in excel can you make a scatter plot with excel creating a scatter graph in excel how to do scatter diagram in excel how to do scatterplots in excel paste new data on a chart in excel Pasting data on an Excel chart is one way to compare two different-sized populations on an XY Scatter chart. Recap: X-Y Scatter Charts with 2 series are difficult to create Create a one-series chart Select the new data, including the headings Click the chart Paste Special Choose X setting Add a legend to tell the series apart Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...