WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Plots in Excel

Plots in Excel

By Dhanamma PandulaDhanamma Pandula | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What Do You Mean By Plots in Excel?

Plots in Excel are defined as the graphs to correlate the data presented in the two columns. Plots are nothing but the scatter diagram or scatter charts in Excel to correlate the data sets in two columns. These are two dimensional XY charts to present the relationship between the two variables and analyze the data in multiple views. It is easy to make the selection of the right scatter plot to perform data analysis.

How to Make Plots in Excel? (with Examples)

You can download this Plots in Excel Template here – Plots in Excel Template

Example#1 – Simple Scatter Plot

To create the simple scatter plot, place the data into two columns, as shown in the screenshot.

Plots Excel Example 1

Step 1: Select the data, including the two columns, such as the advertising expenses and a number of items sold along with their column headers.

In this situation, the range of data in B1:C10.

Plots Excel Example 1-1

Step 2: Go to the insert tab and move to a scatter plot and place the cursor, as shown in the figure.

Plots Excel Example 1-2

Step 3: Choose the scatter plot to represent the relationship between the data sets.

Plots Excel Example 1-3

The scatter plot is developed, as shown in the below-mentioned figure.

Plots Excel Example 1-4

We can change the format and design of the chart area using the design and format tab.

Example#2 – Scatter Plot with Smooth Lines and Markers

To create the simple scatter plot with lines and markers, place the data into two columns, as shown in the screenshot.

Plots Excel Example 2

Step 1: Select the data, including the two columns, such as the advertising expenses and a number of items sold along with their column headers. In this situation, the range of data in B1:C10.

Plots Excel Example 2-1

Step 2: Go to the insert tab and choose the scatter plot with markers and lines to represent the relationship between the data sets.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Plots Excel Example 2-2

The scatter plot with lines and markers is shown in the below-mentioned figure.

Plots Excel Example 2-3

Example#3 – Scatter Plot with Smooth Lines

To create the simple scatter plot with smooth lines, place the data into two columns

Plots Excel Example 3

Select the data, including the two columns, such as the advertising expenses and a number of items sold along with their column headers. In this situation, the range of data in B1:C10.

Plots Excel Example 3-1

Go to the insert tab and move to a scatter plot, and choose the scatter plot with lines to represent the relationship between the data sets.

Plots Excel Example 3-2

The scatter plot is developed, as shown in the below-mentioned figure.

Plots Excel Example 3-3

Example#4 – Scatter Plot with Straight Lines and Markers

To create the simple scatter plot with straight lines and markers, place the data into two columns, as shown in the screenshot.

Example 4

Select the data, including the two columns, such as the advertising expenses and a number of items sold along with their column headers. In this situation, the range of data in B1:C10.

Example 4-1

Go to the insert tab and move to a scatter plot, and choose the scatter plot to represent the relationship between the data sets.

Example 4-2

The scatter plot is developed, as shown in the below-mentioned figure.

Example 4-3

Change the chart type to scatter with straight lines, as shown in the figure.

Example 4-4

The scatter with straight lines is developed, as shown in the below-mentioned figure.

Example 4-5

Example#5 – Bubble Chart

To create the simple bubble plot, place the data into two columns, as shown in the screenshot.

Create Bubble Chart Example 5

Select the data, including the two columns, such as the advertising expenses and a number of items sold along with their column headers. In this situation, the range of data in B1:C10.

Create Bubble Chart Example 5-1

Go to the insert tab and move to the bubble plot and choose the bubble plot to represent the relationship between the data sets.

Create Bubble Chart Example 5-2

The bubble plot is developed, as shown in the below-mentioned figure.

Create Bubble Chart Example 5-3

Change the chart type to a 3D bubble plot, as shown in the figure.

Create Bubble Chart Example 5-4

The 3D bubble plot is developed, as shown in the below-mentioned figure.

Create Bubble Chart Example 5-5

Applications

Scatter plots have different applications. These are used in

  • Resolve a problem through data analysis
  • Determining the correlation between the independent and dependent variables.
  • It is used as a quality tool in determining the causes of a problem.
  • It is used for testing the autocorrelation in prior to building the control charts in quality analysis.
  • It helps to show the non-linear pattern.
  • A user can easily identify the minimum and maximum value in the range of data flow.
  • Three kinds of relationships between variables, such as no relation, positive, and negative relationships, are analyzed effectively by using the scatter plot. It helps to understand how changes in one factor will affect another factor.

Things to Remember

  • It is hard to create the chart if the data of a variable is presented in a non-numeric format
  • A small amount of data is useful in practicing performing of the better data analysis with the scatter plot
  • It needs to take care of while performing proper data analysis without any errors
  • The user has to understand how to properly utilize and interpretation of data carefully
  • Always add colors and change the format of the chart to enhance the visual appearance to users

Recommended Articles

This has been a guide to Plots in Excel. Here we learn how to make scatter plots by using a Scatter plot with smooth lines, a Scatter plot with straight lines and markers, and a Bubble chart along with examples and downloadable templates. You may learn more about excel from the following articles –

  • Box Plot in Excel
  • Make 3D Plot in Excel
  • Dot Plots in Excel
  • Make Chart Templates in Excel
  • DATEVALUE Excel Function
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Download Coursera IPO Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Plots in Excel Template

Coursera IPO Financial Model & Valuation Free Download