View previous topic :: View next topic |
Author |
Message |
McGruber
Joined: 12 Aug 2014 Posts: 237 Location: Idaho
|
Link Posted: Mon Dec 12, 2016 9:02 pm Post subject: Excel graph help |
|
|
I ran a cooling experiment on the fermentation cabinets I'm building, and created a spreadsheet to track temperature over time. I can't seem to figure out how to get the X-axis to show a linear progression of time over 50 hours, and the data points to correspond to the temperatures at "hours after 09:55 AM". I've watched a few online videos, but so far they haven't shown me what to do. I've attached a screenshot, and the actual Spreadsheet. Any help is appreciated.
Link to Cabinet Build: http://www.theelectricbrewery.com/forum/viewtopic.php?p=320736#320736
Link to Brewery Build: http://www.theelectricbrewery.com/forum/viewtopic.php?t=28523
Description: |
|
Filesize: |
86.17 KB |
Viewed: |
10604 Time(s) |
|
Description: |
|
Download |
Filename: |
Fermentation cabinet temperature test.xlsx |
Filesize: |
50.21 KB |
Downloaded: |
639 Time(s) |
Last edited by McGruber on Fri Dec 16, 2016 7:12 pm; edited 2 times in total
|
|
Back to top |
|
|
Yo_Pauly
Joined: 30 Nov 2014 Posts: 42 Location: New Richmond, WI
|
Link Posted: Tue Dec 13, 2016 3:02 am Post subject: |
|
|
It looks like the plot type you chose was a line graph but what you want instead is an X-Y plot. By default Excel will use the left most column of your selected data as the X-axis for the X-Y plot, so ignore the first column and select the "Hours after 9:55" along with the three columns to the right and create a new X-Y plot from the list of chart types.
|
|
Back to top |
|
|
David_H
Joined: 13 Nov 2013 Posts: 139 Location: Savannah, GA
Drinking: Dry Irish Stout, Electric Pale Ale, American Amber Ale, Irish Red Ale
|
Link Posted: Tue Dec 13, 2016 2:14 pm Post subject: |
|
|
Select all four columns and then select SCATTER PLOT.
_________________ David
Kal Clone Controller
20 gallon Spike Brewing 3-Kettle System
SS Brewtech 14 gallon fermenter w/ gycol chiller
4 tap keezer with Nitro Tap
|
|
Back to top |
|
|
McGruber
Joined: 12 Aug 2014 Posts: 237 Location: Idaho
|
Link Posted: Tue Dec 13, 2016 4:54 pm Post subject: |
|
|
Thanks for the prompt help. That worked! I'm going to try to finish the trim on the cabinets today and will post pictures soon.
Description: |
|
Filesize: |
81.02 KB |
Viewed: |
10543 Time(s) |
|
|
|
Back to top |
|
|
|
|