How to create a scatter chart

[Mohsen_2020]

Dear @Ashish_Mathur , Hope you are doing well,

I neeed tour help to create a scatter chart using the attached link file. 

Chart will show the visits per segmentation starting from jaunuary till April 2021.

File link: https://drive.google.com/file/d/1Kr5oCvfMrxB4OfSeGcklndiOo_4eZi7f/view?usp=sharing

Regards,

Mohsen

[Mohsen_2020]

The excel file contains activities by date and it was done by reps to a clients. 

the clients are classified and classification here named segment so we need to present the activities by segment as showing in the below graph, please help. 

[Ashish_Mathur · Accepted solution]

Hi,

A scatter chart has numerical values on box axis whereas you want months on the X axis.  Create a simple line chart and remove the line from the line chart (let the markers remain on the line chart).

[Ashish_Mathur]

I do not understand your question at all.