Look Who it Was Random video

Excel - Chart Creation in Excel: Create Charts with Multiple Series Efficiently - Episode 1032

944 views · Published 9 June 2009 · 3:50 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Chart Creation in Excel: Create Charts with Multiple Series Efficiently.

Welcome back to the MrExcel netcast! In this episode, we're diving into the world of data analysis in Excel. We'll be taking a look at how to create a pivot table and solve a common problem that many Excel users face.

Have you ever had to create an XY chart with multiple series and found yourself adding each series one by one? It can be a tedious and time-consuming process. In this video, we'll explore a more efficient way to handle this task.

I'll show you how to set up a data set with all the series names and then use the insert scatter chart feature to quickly create the chart. We'll then go through each series and choose the correct data points, making sure the chart is accurate and visually appealing.

While this method may not be the most intuitive, it is a great way to save time and effort when creating charts with multiple series. Plus, it ensures that the correct number of series is included in the chart, avoiding any confusion or errors.

Once we have our chart set up, we'll go through the steps to change the markers to circles and adjust the colors. If you need a refresher on these steps, be sure to check out our previous netcast where we cover these techniques in detail.

I know some of you may have resorted to creating charts in PowerPoint because you thought it couldn't be done in Excel. But I'm here to tell you that it can be done! While it may not be the most user-friendly method, it is possible to create charts with multiple series in Excel.

Thank you for tuning in to this episode of the MrExcel netcast. I hope you found this tutorial helpful and that it saves you time and effort in your future data analysis projects. Be sure to subscribe to our channel for more Excel tips and tricks, 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-on-youtube/


Yesterday's podcast showed a tedious method for creating a chart with 5 XY series. Today, Episode 1032 shows a method for streamlining the creation of this chart.
This is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of 377 tips from the book!

Table of Contents:
(00:00) Introduction to the MrExcel netcast with Bill Jelen
(00:10) Challenge for viewers to solve
(00:20) Difficulty in creating a chart with multiple series
(00:32) Fooling Excel to create desired chart
(01:11) Building a fake data set for easier chart creation
(01:22) Choosing and arranging series for chart
(02:30) Completing the chart creation process
(03:12) Alternative methods for creating the chart
(03:28) 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 

This video answers these common search terms:
Changing marker colors in Excel charts
Changing markers to circles in Excel charts
Creating charts with multiple series in Excel
Creating charts with specific marker shapes and colors in Excel
Creating x y charts with multiple series in Excel
Easier method to add multiple series to a scatter chart in Excel
Excel vs PowerPoint for creating complex charts
Fooling Excel to display the correct number of series in a chart
How to add series to a scatter chart in Excel
How to create scatter charts in Excel
Solving chart creation problems in Excel
YouTube video on analyzing data with pivot tables

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152449/

More from this channel