date on x axis of scatter chart is incorrect

in my spread sheet I have a column of dates formatted as dd-mmm-yy. The dates range from 5 may 11 to
17 mar 17

The spread sheet also has a column of systolic blood pressures. the pressure data may or may not exist for many of the dates.

If I choose a line chart the blood pressure shows up just as I had imagined it would

But If i choose a scatter chart, I would have expected the data to be plotted against the dates found in
the spread sheet. Instead the data ends up as one glob of data.

Looking carefully at the chart date data I observed the dates are not copied correctly. I would get dates like 3 oct 54 which is totally incorrect.

I know the dates are formatted in the spread sheet. Perhaps the graph does not know how to look at the data format and thus guesses the format and in so doing gives me some weird answer.

I looked on the web for help, but most of the help referred to excel of an old year. My excel is office 365 and so is up todate. if I right click on the graph I do not get "tools" and hence i can not get at formating for the axis as advised.

Any pointers?

thank you
bil

(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's hard to tell exactly because you scatter chart is based on data in another workbook.

But the series on the left has no x values so is defaulting to a sequential increment value. Try setting the x values to those used by the other series.

See if this is an improvement. The data has been condensed so that it includes only those data points where blood pressure readings were taken by using aggregate based formulas. The horizontal axis is formatted to show data between July 31, 2012 and April 26, 2015.

You're Welcome and thank you for the feedback. Let us know if you need help figuring out what the formulas do. Also, please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.

The data for the xy-scatter comes from
=SERIES("diastolic",,'C:\362d23dbdc611807\Butterfly Data\Butterfly Docs\ActivityCenters\Life\People\Personal\CC health\Prevention\health measurements\[health measurements 5 jun 15 .xlsx]Raw Data'!R4C5:R685C5,2)

You have a bad date in your data, cell R127C2. Correct that and you should be able to use the dates as the x values in a line graph. If you want a true xy-scatter then make sure both x and y series have correct range references.
A line chart will treat the x axis as dates.