+ Reply to Thread
Results 1 to 8 of 8

How to plot both ch1 and ch2 data for temperature on same graph

  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2007
    Posts
    2,302

    How to plot both ch1 and ch2 data for temperature on same graph

    Hi,

    I recently received a weather station thingy for christmas and it has like 8 channels/sensors. SO i put the sensors all over my house and it collects data for each sensor. So i wanted to plot just two of the sensors (see enclosed data) using excel but for some reason is seems kinda hard .

    What i want to do is ON THE SAME PLOT show channel 1 and channel 2 temperature.

    Is this possible? and if so how
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,206

    Re: How to plot both ch1 and ch2 data for temperature on same graph

    The readings seem to occur every 5 minutes - do you need to plot them with that frequency? It might be better to produce a summary table from the data where you aggregate all the readings in, say, 15-minute increments. This summary table would have a column for date/time, and then a column for Ch1 and another for Ch2 (using the AVERAGEIFS function to average the temperatures within each time-slot). and then you would use this table as the source for your graph.

    Hope this helps.

    Pete

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,591

    Re: How to plot both ch1 and ch2 data for temperature on same graph

    Short but useless answer -- yes this is possible. I'm not sure exactly how to answer the how part of the question. there are obviously multiple steps needed to get the data into a chart, and I'm not sure which step(s) you would have trouble with. Here's how I would expect to proceed:

    1) Import text data into Excel/spreadsheet app -- maybe as simple as File -> Open or Import External Data -> From text.
    2) Rearrange the data so that date/time stamps are in the left column, desired Channel+temp labels are in successive columns moving to the right:
    Please Login or Register  to view this content.
    A pivot table may be the quickest/easiest way to rearrange the data like this, or some other formula/utility.
    3) With the data rearranged, simply select the table and insert the desired chart.

    Something like that should work just fine until your data set exceeds the total number of points allowed for a data series (something like 32000 points per series and 250000 points over all data series in Excel 2007 -- assuming that is still correct in your profile).

    Which step do you have trouble with?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2007
    Posts
    2,302

    Re: How to plot both ch1 and ch2 data for temperature on same graph

    hi,

    i tried the pivot table thing.........really could not get it to work like i wanted.

    what i want is basically a line graph for each channel ........but on the same graph..........

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,591

    Re: How to plot both ch1 and ch2 data for temperature on same graph

    Without some detail (or maybe a sample file) of what you tried, it is difficult to know what went wrong. What did your pivot table look like when it was done? Left column contained the date/time stamps and other columns with the temperatures? Did you fail to get any kind of line chart, or did you get a line chart and didn't like something about it?

  6. #6
    Registered User
    Join Date
    01-21-2020
    Location
    Portland, Oregon
    MS-Off Ver
    95
    Posts
    7
    Actually a pivot chart should be able to display both channels on one graph.

  7. #7
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2007
    Posts
    2,302

    Re: How to plot both ch1 and ch2 data for temperature on same graph

    here is the data.....
    Attached Files Attached Files

  8. #8
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,591

    Re: How to plot both ch1 and ch2 data for temperature on same graph

    I'm not sure what difficulties you are having. Here's what I did with your .csv file:

    1) Open file in Excel -- Excel automatically parses the text file according to its default settings, and I get channel, time, temperature, humidity, dewpoint, heat index columns.
    2) Select the source data -> Insert -> Pivot table.
    3) From pivot fields panes, drag time into the row labels field, channel into the column labels field, and sum of temperature into the values field.
    3a) Because of the index row between channels, the pivot table adds a "time" row and a "channel" column -- I can use the dropdown arrows on the row and column labels to filter these out.
    4) Select the pivot table -> Insert -> chart -> regular line.

    At this point, I have a line chart with date/time along the horizontal axis, temperature on the vertical axis, and two line series showing the temperature for each channel. Does that process work for you? What did you do differently? Are you satisfied with those results, or do you need it to do more?

+ 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