Hi,
I'm looking at data in relation to July (1-31). I have data for the days 21-31, 22-31 and 25-31. I've inputted my data in the corresponding numbered rows. However, when I go to create my graph (scatter line graph) the data is all offset by a day. So the graph shows 20-30, 21-30 and 24-30, respectively. How can I remedy this? I've attached a screenshot to help explain.
Many thanks
Lony
excel.jpg
are you confusing row number of the sheet with data point value?
Your data starts in row 2 not row 1 of the sheet.
Hi,
I am sorry but I do not understand what you mean
Post example workbook rather than picture.
Hi, Do you mean the Excel file?
Yes. That is correct.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you - Here it is
July cholera cases plymouth.xlsx
OK, so what do you want plotted on the X-Axis? I assume that you want days of the month. So, for the Plymouth & Davenport Weekly, what date do you want the first two cases to appear against?
OK, figured it out. I'm a bit slow today. This should be what you want. You hadn't specified the X-axis correctly. If this is OK, please mark the thread as closed & (if I've helped) click the "add reputation" star below my name at the foot of this post.
If it's not OK, ask again!!
Thank you so very much!
I really apreciated it
You are very welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks