Go Back   Computer Forums > General Computing > Software and Operating Systems
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 11-07-2013, 06:36 AM   #1
Fully Optimized
 
BikerEcho's Avatar
 
Join Date: Feb 2011
Location: Denmark
Posts: 4,013
Default Any Google Spreadsheet users out there that can help me?

I have this graph in Google Spreadsheet that i have created to show how much money each year that have been used for IT stuff.
I can't make the graph add the year 2013 to it's calculations because it's not inline with the other years. I don't want to use any more space downwards. How can i add the year (+ data ofcause) to the graph?


capture screen
__________________

__________________
MOBO: Asus Maximus 6 Hero - GPU: Gigabyte GTX 980ti xtreme - CPU: I7-4770K - PSU: Corsair AX760
RAM: Corsair Vantage 2x4GB - SSD: Samsung 840 EVO 512 + LiteOn LCS-256 - Case: NZXT H440
BikerEcho is offline   Reply With Quote
Old 11-07-2013, 07:25 AM   #2
Fully Optimized
 
ssc456's Avatar
 
Join Date: Jan 2007
Posts: 4,279
Send a message via MSN to ssc456
Default Re: Any Google Spreadsheet users out there that can help me?

Hey,

I've not used Google Spreadsheet but in Excel you would just CTRL Click the second range and it will add it and format it as:

=Sheet1!$A$1:$D$2+Sheet1!$G$1:$J$2
__________________

__________________
He who has never failed has never attempted anything worth succeeding at.

Dont Eat Animals, Its Not Good For Them And They Dont Like It!
ssc456 is offline   Reply With Quote
Old 11-07-2013, 07:25 AM   #3
In Runtime
 
Mossiac's Avatar
 
Join Date: Jan 2013
Location: UK
Posts: 357
Default Re: Any Google Spreadsheet users out there that can help me?

Have you tried a commar after A11 and then put the ref that it needs to point to after that. So that you get something that look like the following.

Sheet1!A4:A11,C4:C11

Hope this solves the problem.

Mossiac
__________________
OS: Windows 7 64-bit Case: Commander MS-I
Mother Board: GA-880GM-UD2H CPU: AMD PhenomII X4 965 3.4GHz(Stock) RAM: 16GB GPU: GeForce GTX 550 Ti
Mossiac is offline   Reply With Quote
Old 11-07-2013, 07:30 AM   #4
Fully Optimized
 
BikerEcho's Avatar
 
Join Date: Feb 2011
Location: Denmark
Posts: 4,013
Default Re: Any Google Spreadsheet users out there that can help me?

I have tried pressing control and that didn't work.
i have also tried putting in a "+" after Sheet1!A4:A11.
So it's Sheet1!A4:A11+C3

---------- Post added at 01:30 PM ---------- Previous post was at 01:28 PM ----------

Mossiac:
I just tried it. (Sheet1!A4:A11,C4, Sheet1!A4:A11,D4)
But unfortunately that didn't work ether
__________________
MOBO: Asus Maximus 6 Hero - GPU: Gigabyte GTX 980ti xtreme - CPU: I7-4770K - PSU: Corsair AX760
RAM: Corsair Vantage 2x4GB - SSD: Samsung 840 EVO 512 + LiteOn LCS-256 - Case: NZXT H440
BikerEcho is offline   Reply With Quote
Old 11-07-2013, 07:34 AM   #5
In Runtime
 
Mossiac's Avatar
 
Join Date: Jan 2013
Location: UK
Posts: 357
Default Re: Any Google Spreadsheet users out there that can help me?

I knew it was something between the two sets of points. I couldn't quite remember and that sort of thing is usually a commar. But glad it's sorted.

Mossiac
__________________
OS: Windows 7 64-bit Case: Commander MS-I
Mother Board: GA-880GM-UD2H CPU: AMD PhenomII X4 965 3.4GHz(Stock) RAM: 16GB GPU: GeForce GTX 550 Ti
Mossiac is offline   Reply With Quote
Old 11-07-2013, 09:59 AM   #6
Fully Optimized
 
strollin's Avatar
 
Join Date: Mar 2011
Location: USA
Posts: 1,943
Default Re: Any Google Spreadsheet users out there that can help me?

Did you try clicking on the link "Add another range" there on the graph?
strollin is online now   Reply With Quote
Old 11-07-2013, 10:36 AM   #7
Fully Optimized
 
BikerEcho's Avatar
 
Join Date: Feb 2011
Location: Denmark
Posts: 4,013
Default Re: Any Google Spreadsheet users out there that can help me?

I just tried it.
as i though it's to add in more data. Like if you want to benchmark more then 2 graphic cards.

It's weird that it isn't easier to do (if even possible).
__________________
MOBO: Asus Maximus 6 Hero - GPU: Gigabyte GTX 980ti xtreme - CPU: I7-4770K - PSU: Corsair AX760
RAM: Corsair Vantage 2x4GB - SSD: Samsung 840 EVO 512 + LiteOn LCS-256 - Case: NZXT H440
BikerEcho is offline   Reply With Quote
Old 11-12-2013, 12:33 PM   #8
Fully Optimized
 
jmacavali's Avatar
 
Join Date: Jun 2009
Posts: 4,867
Default Re: Any Google Spreadsheet users out there that can help me?

Ithink the problem is that you can't use the range. If you put each cell you want to total, with a comma between them, it should work.

=sum(b4,b5,b6,b7,b8,b9,b10,b11,d4)

Since it's a small spreadsheet, that should work fine.


Actually I just did this on my test spreadsheet and it worked to: =sum(a2:a4,b1).

Looks like you just need a comma instead of an exclamation mark.
__________________
****************************************
Don't take life too seriously -- no one gets out alive. Plus, who wants to arrive to the hereafter in pristine condition wearing a suit and tie?
I want to slide in sideways, worn out, used up, hair a mess, clothes tattered, & screaming, "Whooo! What a ride!"
****************************************
jmacavali is offline   Reply With Quote
Old 11-12-2013, 02:33 PM   #9
Fully Optimized
 
BikerEcho's Avatar
 
Join Date: Feb 2011
Location: Denmark
Posts: 4,013
Default Re: Any Google Spreadsheet users out there that can help me?

Thanks for replying.
I am not looking for any total number, so "sum" is not gonna do it for me. It's a graph about how much money is used each year on tech.
The =sum(a2:a4,b1). (in my case "=sum(a4:a11,c4)") is not gonna work.

I made a workaround by copying the info to another sheet in a downwards list. That worked ofcause.
__________________
MOBO: Asus Maximus 6 Hero - GPU: Gigabyte GTX 980ti xtreme - CPU: I7-4770K - PSU: Corsair AX760
RAM: Corsair Vantage 2x4GB - SSD: Samsung 840 EVO 512 + LiteOn LCS-256 - Case: NZXT H440
BikerEcho is offline   Reply With Quote
Old 11-12-2013, 03:01 PM   #10
Fully Optimized
 
jmacavali's Avatar
 
Join Date: Jun 2009
Posts: 4,867
Default Re: Any Google Spreadsheet users out there that can help me?

Oh...LOL ...just completely missed the graph part of the original post. I guess I hadn't had enough coffee by then yet...sorry about that.
__________________

__________________
****************************************
Don't take life too seriously -- no one gets out alive. Plus, who wants to arrive to the hereafter in pristine condition wearing a suit and tie?
I want to slide in sideways, worn out, used up, hair a mess, clothes tattered, & screaming, "Whooo! What a ride!"
****************************************
jmacavali is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 12:04 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0