Hi all, first time poster and first time user of Excel Forum.... nice site and it seems like a very popular one so hopefully someone can help me
Attached is a sample of an excel document I have which I use to record our water tank levels through out the year. I am having a problem however getting the graph to work properly.
The data is not much yet but it will grow each year of course, So far I only have the last couple of months in 2009, all of 2010 and now the first entry for 2011.
The problem is the date line in that the 2009 line for example is seen to the left where it should be to the right, as in November December, but it shows up on the graph in January and February,
How do I fix that, how do I get it so that I can have a single line graph for each year with its own line in the correct position.
Not sure if my explanation means much and I cannot post images here for whatever reason to highlight the issue, but hopefully if you can open the attachment and see the graph you will know what I mean.
Please teach me what the solution is rather than just give me the solution, I'd like to learn how to fix it
Thanks
GW
Bookmarks