Hello All

I need some help.

I have created a graph to track how my measurements(waist, Arms, Chest, Neck) show via graph,

I started collecting the data as of the 26th Jan and will be updating measurements ever week. So the next day is 2/2/14.

The data field shows this in order however the graph is showing 2/2/14 data before 26/1/14

any ideas. Hope this makes sense.

Hi
Your dates are probably text looking like dates, not real dates.
One way to change this would be to select the range with dates, go to Data -Text to columns - Next - Next and change the Date format to DMY - Then finish
If it does not work, try other variations in the dropdown box.
Then refresh your data

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

No that didn't work

Please post a sample sheet, no pics - Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

sample sheet?

Yes
a sheet containing some data and stripped of any confidential info. See the FAQ for the attachment procedure

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Here you go

Attached Files

Weight Chart1.xlsx (48.4 KB, 13 views)

The dates in your table after 04/05/2014 are not correct, they revert back to April.
I corrected the table to get weekly dates and reselected data for your last graph, the problem with 26/01 stayed , I have no idea why

OTH recreating the "Measurements" graph from scratch solved the problem

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

do you have copy of the spreadsheet.?

Don't worry i have sorted it. Thanks for your assistance