Forum Discussion
How to create a scatter chart
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
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).
3 Replies
I do not understand your question at all.
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.
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).
