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.5"> <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.5">Graphs (Excel or not)</a> </h3> <div id="messages" data-navigation="41396_5_19_10"> <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.4">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.5" 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.5#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.5" 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.5#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.5" 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">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.5" 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.5#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.5" 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.5#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.5" 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><a name="a41396_11"></a><div class="message" id="message_41396_11"> <div class="message_header"> <div class="message_from"> From: Chris (CHRISSS)<span class="message_time">12 Feb 2015 20:29</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 21:04"></span></span> <span class="message_count">11 of 19</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41396.11">41396.11</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41396.5#a41396_9" target="_self">41396.9</a></div> <div class="message_body"> That's perfect. Thank you. I knew there'd be a simple solution but couldn't work it out. Thanks <span class="emoticon e_smile" title=":)"><span class="e__">:)</span></span></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41396.11&return_msg=41396.5" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41396.11"> <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_12"></a><div class="message" id="message_41396_12"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time">12 Feb 2015 22:58</span> <div class="clearer"></div> </div><div class="message_to">To: Chris (CHRISSS) <span><span class="image post_read" title="Read: 13 Feb 2015 00:26"></span></span> <span class="message_count">12 of 19</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41396.12">41396.12</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41396.5#a41396_11" target="_self">41396.11</a></div> <div class="message_body"> Another quick workaround for stuff like this would be doing two graphs and super-imposing in your graphics editor. <p>Obviously not ideal for ongoing changing stuff, but worth remembering you don't always to stick to a spreadsheet. Trend lines are a good example of something that can be a PITA to get right at times, but are easily drawn with vectors.</p></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41396.12&return_msg=41396.5" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41396.12"> <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_13"></a><div class="message" id="message_41396_13"> <div class="message_header"> <div class="message_from"> From: 99% of gargoyles look like (MR_BASTARD)<span class="message_time">13 Feb 2015 07:27</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 14 Feb 2015 14:23"></span></span> <span class="message_count">13 of 19</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41396.13">41396.13</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41396.5#a41396_12" target="_self">41396.12</a></div> <div class="message_body"> <div class="quotetext"><b>quote:</b> <a href="messages.php?webtag=DEFAULT&msg=41396.12">Peter (BOUGHTONP)</a></div> <div class="quote"> <p>Trend lines are a good example of something that can be a PITA to get right at times, but are easily drawn with vectors.</p> </div> <p>Select data, right click, add trend line, select trend line that best fits the data. Gives you equation and R<sup>2</sup> to boot. What's so difficult about that?</p> <div class="edit_text">EDITED: 13 Feb 2015 07:27 by MR_BASTARD</div> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41396.13&return_msg=41396.5" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41396.13"> <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_14"></a><div class="message" id="message_41396_14"> <div class="message_header"> <div class="message_from"> From: koswix<span class="message_time">13 Feb 2015 08:18</span> <div class="clearer"></div> </div><div class="message_to">To: Chris (CHRISSS) <span><span class="image post_read" title="Read: 13 Feb 2015 08:40"></span></span> <span class="message_count">14 of 19</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41396.14">41396.14</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41396.5#a41396_7" target="_self">41396.7</a></div> <div class="message_body"> Ah, right. Also thought it was the scale. </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41396.14&return_msg=41396.5" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41396.14"> <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.15" dir="ltr" /><input type="submit" name="submit" id="keep_reading" value="Keep reading…" class="button" /></form></li> </ul> </div> </div> </body>