Jump to content

Terrible at Google Sheets

DarkBlade2117

Ok... just trying to make a simple line chart though can't seem to figure out how to get the horizontal values to show up. ld07zGu.pngI

I essentially want my chart to look more like this, rather than the one above.

image.png.076dad6bc6efdbb8dcc1c828898d1de3.png

 

 

 

i7-6700k  Cooling: Deepcool Captain 240EX White GPU: GTX 1080Ti EVGA FTW3 Mobo: AsRock Z170 Extreme4 Case: Phanteks P400s TG Special Black/White PSU: EVGA 850w GQ Ram: 64GB (3200Mhz 16x4 Corsair Vengeance RGB) Storage 1x 1TB Seagate Barracuda 240GBSandisk SSDPlus, 480GB OCZ Trion 150, 1TB Crucial NVMe
(Rest of Specs on Profile)

Link to comment
Share on other sites

Link to post
Share on other sites

You are doing something wrong somewhere. By default it will pick the first column as x

 

diagram1.png

diagram2.png

Link to comment
Share on other sites

Link to post
Share on other sites

21 minutes ago, Dujith said:

You are doing something wrong somewhere. By default it will pick the first column as x

 

diagram1.png

diagram2.png

I got it kind of figured out now. Though messing around with settings I can't get the second line to appear now? 6xBrHzu.png

 

 

 

i7-6700k  Cooling: Deepcool Captain 240EX White GPU: GTX 1080Ti EVGA FTW3 Mobo: AsRock Z170 Extreme4 Case: Phanteks P400s TG Special Black/White PSU: EVGA 850w GQ Ram: 64GB (3200Mhz 16x4 Corsair Vengeance RGB) Storage 1x 1TB Seagate Barracuda 240GBSandisk SSDPlus, 480GB OCZ Trion 150, 1TB Crucial NVMe
(Rest of Specs on Profile)

Link to comment
Share on other sites

Link to post
Share on other sites

Thats because any diagram needs at least 2 columns 1 for the y axis and 1 for the x axis.

If you want the current and voltage to appear as two lines, you will need a reference for them both. Like time or something else.

 

diagram3.png

Link to comment
Share on other sites

Link to post
Share on other sites

23 minutes ago, Dujith said:

Thats because any diagram needs at least 2 columns 1 for the y axis and 1 for the x axis.

If you want the current and voltage to appear as two lines, you will need a reference for them both. Like time or something else.

 

diagram3.png

I'm sorry, just stressed and what not right now. I've been kind of doing this wrong. I essentially want to take this information here and put it in a line graph. It's using slope to get the lines, so the 820 Ohm is one line and the 1.2k"Ohm" is another line. The Vertical axis is meant to be Current and the Horizontal axis is Voltage. I know my issue is I just don't know how to  how to put the information in Google sheets so that it show sup n the graph correctly.

05aNxrB.png

 

 

i7-6700k  Cooling: Deepcool Captain 240EX White GPU: GTX 1080Ti EVGA FTW3 Mobo: AsRock Z170 Extreme4 Case: Phanteks P400s TG Special Black/White PSU: EVGA 850w GQ Ram: 64GB (3200Mhz 16x4 Corsair Vengeance RGB) Storage 1x 1TB Seagate Barracuda 240GBSandisk SSDPlus, 480GB OCZ Trion 150, 1TB Crucial NVMe
(Rest of Specs on Profile)

Link to comment
Share on other sites

Link to post
Share on other sites

Ah, well i always fight with graphs in excel and here. So i'm hoping someone else sees this and has some more experience with this. 

 

I understand what u want to do, but atm don't know how to achieve that besides using 2 graphs :( sorry

Link to comment
Share on other sites

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×