Use Scatter Chart in Microsoft Excel 365!!! ~ easy tricks!!
Tags: usescatterchart
Published: 2021-08-17 03:44:27

---
title: Use Scatter Chart in Microsoft Excel 365!!! ~ easy tricks!!
published: true
date: 2021-08-11 16:38:43 UTC
tags: UseScatterChart
canonical_url: https://geekexcel.com/use-scatter-chart-in-microsoft-excel-365-easy-tricks/
---

In this tutorial, we will guide you to know the step-by-step instructions to **Use Scatter Chart In Microsoft Excel 365.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

Scatter Chart contains 7 types of Column charts, Scatter, Scatter with Smooth Lines and Markers, Scatter with Smooth Lines, Scatter with Straight Lines and Markers, Scatter with Straight Lines, Bubble, and 3-D Bubble.

## Scatter with Straight Lines

- Firstly, you have to **create the table with data**.
- For instance, we have shown the **company turn over details** below.

![](https://geekexcel.com/wp-content/uploads/2021/08/list-of-turn-over-1.png)<figcaption>List of turnover details</figcaption>

- From the table, you need to **select the range A1:C13**.
- Then, you have to click on the **Insert** tab.
- Now, you need to **select the scatter**  **chart** under the **[Chart](https://geekexcel.com/create-bar-charts-in-excel-office-365-simple-easy-steps/)**section.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-chart-type.png)<figcaption>Click on Chart type</figcaption>

- After selecting the **chart type** , you will see the list of items in the **chart format**.

![](https://geekexcel.com/wp-content/uploads/2021/08/scatter-chart.png)<figcaption>Scatter Chart</figcaption>

- You have to go to the **Design contextual tab** and choose any chart from the **Chart Styles group**.
- Then, you need to click on **Add Chart Element** and a dropdown list will appear.
- Now, from the **drop-down** menu, you have to click on **Data Labels**.
- After that, again **drop down** menu will appear after clicking on the **Data Labels** and then click on **center**.
- Then, to **add the chart title** , you have to **double-click** on the title.
- Now, you need to **rename the text** as per the requirement, or you can **delete** it.

![Scatter Chart Style](https://geekexcel.com/wp-content/uploads/2021/08/Dhhr3SgsjE.png)<figcaption>Scatter Chart Style</figcaption>

## Bottom-Line:

So yeah guys, this is how you can **Use Scatter Chart In Microsoft Excel 365**. Leave a comment or reply below, let me know what you think!!!

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

**Read Ahead:**

- **[Insert Sheet in Microsoft Excel 2007?](https://geekexcel.com/insert-sheet-in-microsoft-excel-2007/)**
- **[How to Create or Insert Bubble Chart in Microsoft Excel 365?](https://geekexcel.com/how-to-create-or-insert-bubble-chart-in-microsoft-excel-365/)**
- **[Excel Formulas to Extract Multiple Lines From a Cell ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-extract-multiple-lines-from-a-cell-easy-tricks/)**
- **[Split Multiple Lines From a Cell into Separate Rows in Excel!!](https://geekexcel.com/split-multiple-lines-from-a-cell-into-separate-rows-in-excel/)**