Excel Chart with one legend and independent x y data

[stolba]

Hello Guys, I have some difficulties with charts and not sure even its possible to be solved but I hope you can help me to find a solution, I do know some vba as well if it will be a solution
I have data like this
Date X Y
5/7/2018 2.98 2.02
5/9/2018 2.14 2.38

I need chart which will show points depended on X Y and show date in legend
I am uploading picture hope you will see what I need

[MrShorty]

I see a couple of ways to approach this:

A) If you use the built in legend, then each point must be added to the chart (can I assume it is an XY scatter chart?) as a separate data series. ASsuming an XY scatter chart:
A1) Insert XY scatter chart with one of the points (Excel may not get it right at chart creation, but we'll fix that next).
A2) Bring up the select data dialog (https://support.office.com/en-US/Art...f-79983125df12 ). Edit the first data series (if Excel got it wrong at chart creation) so that:
A2a) The appropriate cell is in the Y values field.
A2b) The appropriate cell is in the X values field.
A2c) The appropriate date cell is in the Series name field.
A3) Add a new series for each data point filling out the same fields for each data series. Repeat until all data points are added to the chart.
This should be easy even if it is tedious. It can be automated with VBA, if desired, but it might take longer to write, test, and debug a VBA procedure than it takes to add the series manually one at a time.

B) Instead of using a legend, use Data labels to attach the appropriate date to each data point.
B1) Select entire X and Y ranges and insert XY scatter chart.
B2) Using something like Rob Bovey's XY chart labeler add-in (pre-2013) or the native option (post-2013) add data labels to the single data series and use the dates column for the data labels. If those are true dates and not text strings, the dates may show up as serial numbers. If so, format the data labels to have an appropriate date format.

I would be inclined to go with option B without the legend, but the final choice is up to you.

[stolba]

Thanks mate, I hadn't thought about that, wrote macro and works perfectly