+ Reply to Thread
Results 1 to 4 of 4

Line graph:water tank levels

  1. #1
    Registered User
    Join Date
    01-05-2011
    Location
    Western Australia
    MS-Off Ver
    Excel 2010
    Posts
    7

    Line graph:water tank levels

    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
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,656

    re: Line graph:water tank levels

    You need to change the layout of your data for charting.

    First column should include all dates. You can stack 2010 and 2011 dates under 2009s.
    2nd column should contain Level for 2009 corresponding to the dates in the first column.
    3rd column should contain Level for 2010 corresponding to the dates in the first column.
    4th column should contain Level for 2011 corresponding to the dates in the first column.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-05-2011
    Location
    Western Australia
    MS-Off Ver
    Excel 2010
    Posts
    7

    re: Line graph:water tank levels

    So what about the fact that the dates may differ throughout the year to the dates used in the previous year? Do I start a column with every date of the year? Then register the data next to the relevant date when I get around to checking the levels?

    Cheers

    GW
    --
    If you don't ask......

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,656

    re: Line graph:water tank levels

    If you use a date axis rather than category axis then the position of each data point will be correctly reflected.

    See attached for new layout and chart.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1