Howdy,

For some reason, I can't figure out how to get an XYScatterLine chart to display data.

I am doing this:

                    if (includeCharts)
                    {
                        WorksheetCell chartStartCell = worksheet.GetCell($"R{dataStartRow}C{colIndex + 3}", CellReferenceMode.R1C1);
                        WorksheetCell chartEndCell = worksheet.GetCell($"R{dataStartRow + 10}C{colIndex + 15}", CellReferenceMode.R1C1);

                        // calculate the data range...
                        WorksheetChart chart = worksheet.Shapes.AddChart(ChartType.XYScatterLinesNoMarkers,
                                                                         chartStartCell,
                                                                         new Point(x: 0, y: 0),
                                                                         chartEndCell,
                                                                         new Point(x: 100, y: 100));

                        // get the data cells figured out
                        var xDataStart= worksheet.GetCell($"R{dataStartRow}C{colIndex}", CellReferenceMode.R1C1);
                        var xDataEnd = worksheet.GetCell($"R{dataEndRow}C{colIndex}", CellReferenceMode.R1C1)
                                                .ToString()
                                                .Split(separator: '!')[1];
                        var yDataStart = worksheet.GetCell($"R{dataStartRow}C{colIndex + 2}", CellReferenceMode.R1C1);
                        var yDataEnd = worksheet.GetCell($"R{dataEndRow}C{colIndex}", CellReferenceMode.R1C1)
                                                .ToString()
                                                .Split(separator: '!')[1];

                        chart.SetSourceData($"{xDataStart}:{xDataEnd},{yDataStart}:{yDataEnd}");
                    }

I'm aware the way I specify cell range for the data source is a bit hokey, but that is because this is the last sample I tried.  I keep thinking I am specifying the cell range in an improper fashion, but what I have is as best I can tell the way you call it out in Excel proper.

The chart ought to be plotting 'Session 1'!$B$24:$B$624 for the x values and 'Session 1'!$D$24:$D$624

What I end up getting is the attached XLSX file.

I can't seem to figure out how to specify the proper cell range.  I tried using the worksheet chart example from your gallery application.

I can get that to work, just not an x/y scatter line chart.

Also, I'd really like to add the chart as its own worksheet, see the Desired.xlsx for what I really want in the end.

P{lease not the styling of the x-Axis with labels below the whole chart is my next challenge if you happen to have an example for that with an XYScatterLine plot I'd love to see that as well.

Thanks in advance for any and all help.

7103.D-Meter_Download_SN496_17May2021_095306.xlsxDesired.xlsx