creating line graphs (constant) when data is changed (dynamic)
Results 1 to 2 of 2

Thread: creating line graphs (constant) when data is changed (dynamic)
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2009
    Posts
    152
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default creating line graphs (constant) when data is changed (dynamic)

    I am trying to find a way to compare some line graphs.
    The data will be in 3 columns, B Date, C Time, D Result.
    There are 288 samples taken per day, but the data may not start at midnight and go until midnight when analyzed.
    Maybe the first sample when a file is opened is 9am, and from then a new sample is added every 5 minutes.
    The data will be replaced every few days, but I want the sheet with calculations to stay the same and read from one tab that I can paste the new data in.

    What I want to do is plot these on a line graph and compare day to day.
    If I have 5 days in data regardless of time, I want to have a line graph for each day.
    I thought I would be able to do this with pivot tables, but I have minimal experience with them and so far not having much luck.

    Looking for suggestions or ideas.

  2. #2
    Board Regular
    Join Date
    May 2009
    Posts
    152
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: creating line graphs (constant) when data is changed (dynamic)

    I don't see an edit button here, but I forgot to also mention that I want each line graph to be the day of data, so some days may have more or less that 288 points. 5 days, 5 lines, each starting with the first point of that day. If it starts at noon, not a big deal if the line starts in the middle of the graph.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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