Need help with a chart , new but learning

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

It looks like a basic scatter chart It sounds like you will have three data series.

Where to begin? This tutorial shows how to create a scatter chart with three data series, all plotted against the same X values: https://www.excel-easy.com/examples/scatter-chart.html The page following this one shows how to access the "select data" dialog where you can add/edit/remove data series. This may be important for you, because you may need this dialog if your three data series will have different X values for each series. I find that a lot of initially creating a scatter chart is in those two steps.

From there, it should be a simple matter of becoming familiar with the different formatting options (colors, symbols, with or without lines connecting the markers, adding error bars, etc.). Learning how to query the help can be a useful skill, as all of these are described somewhere in the help files, if you can only figure out how to find the correct help file.

I have not seen "connected scatter plot" used in Excel communities. Excel communities will use something like "scatter plot with lines and markers". Just semantics, but if you go searching google for stuff, I don't think you will find as much searching for "connected scatter plot".

Adding error bars is usually easy. I have never used the built in "standard error" options, preferring to calculate or estimate my errors in the spreadsheet, and then use those in the chart. Help file for adding error bars: https://support.office.com/en-us/art...5-864049a145f0