EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Charts Plots in Excel  
 

Plots in Excel  

Twinkle Sethi
Article byTwinkle Sethi
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated August 24, 2023

plots in Excel

 

 

Plots in Excel (Table of Contents)
  • Introduction to Plots in Excel
  • Examples of Plots in Excel

Introduction to Plots in Excel

Plots are charts and graphs used to visualize and interpret data so that values for two variables can be represented along the two axes (horizontal axis, i.e., the x-axis, and vertical axis, i.e., the y-axis). Plots are scatter charts that show a graphical relationship between two variables.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Scatter plots display the two data sets’ values using the Cartesian axes or coordinates.

In MS Excel, some layouts that are available for scatter plots are:

  • Simple Scatter plot.
  • Scatter with smooth lines and markers.
  • Scatter with smooth lines.
  • Scatter with straight lines and markers.
  • Scatter with straight lines.
  • Bubble chart.
  • 3-D Bubble chart.

We can interpret the scatter plots in the following manner:

  • If the data points on the plot look like they are randomly scattered, then it implies no correlation between the two variables.
  • The correlation between two variables is strong if the data points are concentrated around a line on the plot.
  • If the data points on a plot are spread widely on the plane, then it implies that the correlation between two variables is weak.
  • The correlation between the two datasets is positive If the data points’ pattern on the plot goes from lower left to upper right.
  • The correlation between the two datasets is negative if the data points’ pattern on the plot goes from upper left to lower right,

Examples of Plots in Excel

Lets us discuss the examples of Plots in Excel.

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

Example #1 – Simple Scatter Plot

Suppose there is an interrelated dataset where we have some people’s monthly salaries and expenditures. Now the relation between salary and expenditure can Plott in Excel with the help of a scatter plot.

We have the following data on monthly salaries and expenditures in an Excel file:
Plots in excel 1-1

To create a scatter plot for this data in Excel, you can follow the following steps:

  • Select the dataset and click on the ‘Insert’ tab. Now select ‘Scatter Chart’:

Plots in excel 1-2

  • With this, we will have the data plotted as follows:

Plots in excel 1-3

Plots in excel 1-4

Now the chart title can be changed by double-clicking on it and then renaming it:

Plots in excel 1-5

  • Now right-click on the scatter lot -> Click on ‘Select Data’:

Plots in excel 1-6

  • On doing this, we will get a popup window:

select data source

  •  In the resulting window, select ‘Salary’ in the ‘Legend Entries’ section, then select Remove.

Plots in excel 1-7

  • Now in the section ‘Legend Entries’, select ‘Expenditure’ in this window, and choose ‘Edit’:

expenditure 1

  • With this, we will have a popup window for the edit series:

Edit Series 1

  •  Now in this ‘Edit Series’ window, select the ‘Salary’ range under ‘Series X values:

series x values

  • This will finally generate the below scatter plot:

3D scatter plot

  •  Now right-click on any data point or dot) -> Select’ Format data Series’:

Format Data Series

  •  With this, we will have a ‘Format Series’ dialog box. In this, click on ‘Effects’ and choose ‘3-D Format’:

format data series 2

format data series -3D Format

  •  Now under ‘3-D Format’, select ‘circle’ type top level:

format data series - level

  •  Now in the ‘Format Series’, choose ‘Fill & Line’ and select ‘Marker’:

format data series -marker

  • Expand the ‘Fill’ option in the ‘Marker’ section -> Select’ Vary colors by point’:

Format data Series

With this, each dot or data point will be represented with a different color

  • Now expand ‘Marker Options’ in the ‘Marker’ section. Choose ‘Built-in’ and then increase the value of size:

plots in excel 1

With this, the data points’ size will be increased.

3D scatter plot1

  • Now on the right of the plot, click on the ‘Plus’ icon to open the ‘Chart Elements’ dialog box:

Chart Elements

Chart Elements 1

  • Now checkmark’ Axis Titles’ in the ‘Chart Elements’ dialog box. In doing this, we will have an ‘Axis Title’ textbox on both axes. (horizontal and vertical

<img class=”alignnone size-full wp-image-343071″ src=”https://www.educba.com/academy/wp-content/uploads/2020/04/Axis-Title.png” alt=%2

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

EDUCBA

Download Plots Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Plots Excel Template

EDUCBA

डाउनलोड Plots Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW