Graphs (Excel or not) - Teh Forum

<body> <div id="header"> <span class="left"> <span class="back"><a href="lthread_list.php?webtag=DEFAULT"><span class="image mobile_back" title="Back"></span></a></span> <span class="image mobile_logo" title="Beehive Forum Logo"></span> </span> <ul> <li> <a class="reply_all" href="lpost.php?webtag=DEFAULT&reply_to=41396.0&return_msg=41396.1"> <span class="image mobile_reply_all"></span><span class="text">Reply to All</span> </a> </li> <li> <a class="navigation" href="#"> <span class="image mobile_navigation"></span><span class="text">Show messages</span> </a> </li> <li> <a class="main" href="#"><span class="image mobile_menu" title="Menu"></span> </a> </li> </ul> </div> <div class="menu main"> <ul> <li><a href="lthread_list.php?webtag=DEFAULT">Messages</a></li> <li><a href="lpm.php?webtag=DEFAULT">Inbox</a></li> <li><a href="lsearch.php?webtag=DEFAULT">Search</a></li> <li><a href="llogon.php?webtag=DEFAULT">Login</a></li> </ul> </div> <div class="menu navigation"><a href="lmessages.php?webtag=DEFAULT&msg=41396.1">1–10</a><a href="lmessages.php?webtag=DEFAULT&msg=41396.11">11–19</a></div> <div id="page_content"> <h3 class="thread_title"><a href="index.php?webtag=DEFAULT&amp;msg=41396.1">Graphs (Excel or not)</a> </h3> <div id="messages" data-navigation="41396_1_19_10"> <a name="a41396_1"></a><div class="message" id="message_41396_1"> <div class="message_header"> <div class="message_from"> From: Chris (CHRISSS)<span class="message_time">12 Feb 2015 18:11</span> <div class="clearer"></div> </div><div class="message_to">To: ALL<span class="message_count">1 of 19</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41396.1">41396.1</a></div> <div class="message_body"> I've got two sets of data which I want to use on the same graph but not sure how to do it like I want. I can get one set working in Excel by using the scatter graph but I want the two sets on there.<br /><br /> The times are in milliseconds, both sets starting at different times and both received at slightly different times, so nothing matches up. How can I synchronise them on the graph?</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41396.1&return_msg=41396.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41396.1"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a41396_2"></a><div class="message" id="message_41396_2"> <div class="message_header"> <div class="message_from"> From: koswix<span class="message_time">12 Feb 2015 19:32</span> <div class="clearer"></div> </div><div class="message_to">To: Chris (CHRISSS) <span><span class="image post_read" title="Read: 12 Feb 2015 19:36"></span></span> <span class="message_count">2 of 19</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41396.2">41396.2</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41396.1#a41396_1" target="_self">41396.1</a></div> <div class="message_body"> Is the time of interest?</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41396.2&return_msg=41396.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41396.2"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a41396_3"></a><div class="message" id="message_41396_3"> <div class="message_header"> <div class="message_from"> From: Chris (CHRISSS)<span class="message_time">12 Feb 2015 19:37</span> <div class="clearer"></div> </div><div class="message_to">To: koswix <span><span class="image post_read" title="Read: 12 Feb 2015 19:54"></span></span> <span class="message_count">3 of 19</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41396.3">41396.3</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41396.1#a41396_2" target="_self">41396.2</a></div> <div class="message_body"> I'd like them to both be in sync, yes.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41396.3&return_msg=41396.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41396.3"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a41396_4"></a><div class="message" id="message_41396_4"> <div class="message_header"> <div class="message_from"> From: koswix<span class="message_time">12 Feb 2015 19:55</span> <div class="clearer"></div> </div><div class="message_to">To: Chris (CHRISSS) <span><span class="image post_read" title="Read: 12 Feb 2015 19:57"></span></span> <span class="message_count">4 of 19</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41396.4">41396.4</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41396.1#a41396_3" target="_self">41396.3</a></div> <div class="message_body"> so you want event 1 in set 1 to graph at the same imaginary time point as event 1 set 2? Then just drop the time table and replace with an numeric index. Select that index as the x-axis data for each data set.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41396.4&return_msg=41396.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41396.4"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a41396_5"></a><div class="message" id="message_41396_5"> <div class="message_header"> <div class="message_from"> From: Chris (CHRISSS)<span class="message_time">12 Feb 2015 20:03</span> <div class="clearer"></div> </div><div class="message_to">To: koswix <span><span class="image post_read" title="Read: 13 Feb 2015 07:43"></span></span> <span class="message_count">5 of 19</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41396.5">41396.5</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41396.1#a41396_4" target="_self">41396.4</a></div> <div class="message_body"> Not sure. Maybe yes or no.<br /><br /> So I have say<br /> 568,19<br /> 1568,19<br /> 2568,19.5<br /> 3568,20<br /><br /> and<br /><br /> 1234,5<br /> 2234,5<br /> 3234,5<br /><br /> So I want both the temps to be using the same time scale and for the points to be in the correct places. I'm not sure if I'm making sense. I'm sure it's easy enough to do.<br /><br /> Also I can't guarantee the same number of samples from each set, if the signal drops, so want the times to still be correct if one set is missing data.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41396.5&return_msg=41396.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41396.5"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a41396_6"></a><div class="message" id="message_41396_6"> <div class="message_header"> <div class="message_from"> From: 99% of gargoyles look like (MR_BASTARD)<span class="message_time">12 Feb 2015 20:20</span> <div class="clearer"></div> </div><div class="message_to">To: Chris (CHRISSS) <span><span class="image post_read" title="Read: 12 Feb 2015 20:21"></span></span> <span class="message_count">6 of 19</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41396.6">41396.6</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41396.1#a41396_5" target="_self">41396.5</a></div> <div class="message_body"> Since x>0, you could try a log scale.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41396.6&return_msg=41396.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41396.6"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a41396_7"></a><div class="message" id="message_41396_7"> <div class="message_header"> <div class="message_from"> From: Chris (CHRISSS)<span class="message_time">12 Feb 2015 20:26</span> <div class="clearer"></div> </div><div class="message_to">To: 99% of gargoyles look like (MR_BASTARD) <span><span class="image post_read" title="Read: 12 Feb 2015 20:26"></span></span> <span class="message_count">7 of 19</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41396.7">41396.7</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41396.1#a41396_6" target="_self">41396.6</a></div> <div class="message_body"> What would a log scale do? I don't remember them too well from school apart from making a curving increasing line.<br /> <br /> I've attached a drawing of what I want. I'm sure its simple. <br /> <br /> X and Y are both the same scale on each set, I just want each point on the graph to correspond to the correct x/y value.</div> <div class="message_attachments"> <span>Attachments:</span> <ul> <li><span class="image attach"></span><a href="get_attachment.php?webtag=DEFAULT&hash=4d44b8be52c777f3c71b6ba2fb506331&filename=Screenshots_2015-02-12-20-24-17.png" target="_blank">Screenshots_2015-02-12-20-24-17.png</a></li> </ul> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41396.7&return_msg=41396.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41396.7"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a41396_8"></a><div class="message" id="message_41396_8"> <div class="message_header"> <div class="message_from"> From: 99% of gargoyles look like (MR_BASTARD)<span class="message_time">12 Feb 2015 20:26</span> <div class="clearer"></div> </div><div class="message_to">To: Chris (CHRISSS) <span><span class="image post_read" title="Read: 12 Feb 2015 20:26"></span></span> <span class="message_count">8 of 19</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41396.8">41396.8</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41396.1#a41396_1" target="_self">41396.1</a></div> <div class="message_body"> Oh, hang on, I think I just figured out your problem. It's not the scale so much as getting both sets of data onto the graph. Correct?<br /><br /> If that's the case, create a table with four columns. Time1, Temp1, Time2, Temp2. Create the scatter plot with Temp1 vs Time1. Then select the graph, right click, and 'select data set' (or something like that, I'm doing this from memory). In the dialogue box create a new data set and set the x to be the Time2 column/boxes, and y to be the matching temp.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41396.8&return_msg=41396.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41396.8"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a41396_9"></a><div class="message" id="message_41396_9"> <div class="message_header"> <div class="message_from"> From: 99% of gargoyles look like (MR_BASTARD)<span class="message_time">12 Feb 2015 20:26</span> <div class="clearer"></div> </div><div class="message_to">To: Chris (CHRISSS) <span><span class="image post_read" title="Read: 12 Feb 2015 20:27"></span></span> <span class="message_count">9 of 19</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41396.9">41396.9</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41396.1#a41396_7" target="_self">41396.7</a></div> <div class="message_body"> I thought the problem was the scale. See ^</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41396.9&return_msg=41396.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41396.9"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a41396_10"></a><div class="message" id="message_41396_10"> <div class="message_header"> <div class="message_from"> From: Chris (CHRISSS)<span class="message_time">12 Feb 2015 20:27</span> <div class="clearer"></div> </div><div class="message_to">To: 99% of gargoyles look like (MR_BASTARD) <span><span class="image post_read" title="Read: 12 Feb 2015 20:27"></span></span> <span class="message_count">10 of 19</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41396.10">41396.10</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41396.1#a41396_8" target="_self">41396.8</a></div> <div class="message_body"> That's what I want, yeah. I'll give that a go, thanks.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41396.10&return_msg=41396.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41396.10"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div></div> <div class="message_page_footer"> <ul> <li class="right_col"><form accept-charset="utf-8" method="get" action="lmessages.php" target="_self"><input type="hidden" name="webtag" id="webtag" class="bhinputtext" value="DEFAULT" dir="ltr" /><input type="hidden" name="msg" id="msg" class="bhinputtext" value="41396.11" dir="ltr" /><input type="submit" name="submit" id="keep_reading" value="Keep reading…" class="button" /></form></li> </ul> </div> </div> </body>