Macro to plot multiple series line in one chart-"scatter with straight lines and markers"

Hello everyone!
My excel sheet is arranged like this:
COLUMN "A" : SERIES NAME- THERE ARE MORE THAN 200 SERIES
COLUMN "B" : DATE- MULTIPLE DATES FOR EACH SERIES NAME, SHOULD BE ON X AXIS
COLUMN "C" : DATA - DATA AGAINST EACH DATE, SHOULD BE ON Y AXIS

PROBLEM: Need to plot one line for each series i.e. more than 200 line in one chart (Chart Type: "SCATTER WITH STRAIGHT LINES AND MARKERS")
Please help!
Thanks in advance.
Attachment is not working hence putting screen shot.
sample.JPG
Regards
Adarsh

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I might ask what you dislike about the way you created the chart, because the chart you have looks correct to me. I expect it was tedious to set up -- needing to define each series individually, but it works.

Data in a list like this is really good for a source database, but is somewhat tedious to work with when charting. Spreadsheet charts are designed to work with data in a table where your X values are in a single column on the left of the table, your series names are in a row across the top, and the body of the table contains the values. Whatever strategy you like for rearranging the data should work just fine for this. Once you have the data rearranged, then creating the chart should be straightforward.

Assuming you are unfamiliar with ways to rearrange the data, two possibilities come quickly to mind:

A) A pivot table can readily rearrange data like this. Insert a pivot table with dates as the row labels, series name as the column labels, and the values in the body of the pivot table (note that this will have trouble if there are more than one entry per date/series pair -- which your example data does not show). Then, because pivot charts cannot be scatter charts, follow the tutorial here for creating a regular chart from pivot table data: https://peltiertech.com/regular-char...-pivot-tables/

B) Something similar to this strategy for "conditional" charts: https://peltiertech.com/conditional-...-excel-charts/ where you add a row of series names (matching the values in column A) at the top of a series of helper columns, then use a simple IF() function to copy the appropriate values into the appropriate columns. Then create the scatter chart from the those helper columns.

I am not familiar with Power Pivot or Power Query, but I would not be surprised if those utilities have tools in them for rearranging the data like this. If you have access to those utilities, you might explore what they can do.