Jump to content

excel graph, how to do it

VUKI656
By VUKI656
in Off Topic
 Share
Posted

So i've been messing around with this for the past one hour and I can't figure it out. Can someone please explain to me how to create this. Everytime I select stuff, it just throws it around how it's not supposed to.

 

Table: https://www.dropbox.com/s/z89sf6hdcq8v5i4/Knjiga1%20%281%29.xlsx?dl=0

post-124566-0-79883700-1431275807_thumb.

Link to comment
https://linustechtips.com/topic/364008-excel-graph-how-to-do-it/
Share on other sites
Link to post
Share on other sites
Posted

Maybe it's better to upload the excel file, and tell us what needs to be in a graph. Maybe one of us can just do it and give you and explain how it's done with your file as an example.

If you want my attention, quote meh! D: or just stick an @samcool55 in your post :3

Spying on everyone to fight against terrorism is like shooting a mosquito with a cannon

Link to comment
https://linustechtips.com/topic/364008-excel-graph-how-to-do-it/#findComment-4931173
Share on other sites
Link to post
Share on other sites
Posted

Type in the the names like Dont use spaces like I did. Pretty much just type in the boxxes in excel exactly how the picture shows it. You need help to make a graph also?

Artikl    Sijecanj

 

Kruh     2,345,00

 

Mlijeko  3,456,00

 

Kava

 

Jogurt

 

Sok

 

Mineralna

 

And ect..

 

 

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
https://linustechtips.com/topic/364008-excel-graph-how-to-do-it/#findComment-4931188
Share on other sites
Link to post
Share on other sites
Posted

On Google Drive it's real simple, just go to Form on the top and go down to Summary of From and you get a bunch of graphs.

24 fps for that "cinematic" feel


After a couple weeks of behavioral sciences at my school I can easily conclude my parents need to grow up.

Link to comment
https://linustechtips.com/topic/364008-excel-graph-how-to-do-it/#findComment-4931189
Share on other sites
Link to post
Share on other sites
Posted
  • Author

Maybe it's better to upload the excel file, and tell us what needs to be in a graph. Maybe one of us can just do it and give you and explain how it's done with your file as an example.

Thank you for the response, heres the Dropbox link cause I can't upload it here: https://www.dropbox.com/s/z89sf6hdcq8v5i4/Knjiga1%20%281%29.xlsx?dl=0

Link to comment
https://linustechtips.com/topic/364008-excel-graph-how-to-do-it/#findComment-4931199
Share on other sites
Link to post
Share on other sites
Posted
  • Author

Type in the the names like Dont use spaces like I did. Pretty much just type in the boxxes in excel exactly how the picture shows it. You need help to make a graph also?

Artikl    Sijecanj

 

Kruh     2,345,00

 

Mlijeko  3,456,00

 

Kava

 

Jogurt

 

Sok

 

Mineralna

 

And ect..

Yeah, i made the table but cant make the graph

Link to comment
https://linustechtips.com/topic/364008-excel-graph-how-to-do-it/#findComment-4931319
Share on other sites
Link to post
Share on other sites
Posted

Yeah, i made the table but cant make the graph

I don't remember exactly but when you highlighted everything and went to insert, You picked a bar and pie graph I seen. Then to get titles you went to LayOut, Chart Title and Axis titles?

 

 

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
https://linustechtips.com/topic/364008-excel-graph-how-to-do-it/#findComment-4931362
Share on other sites
Link to post
Share on other sites
Posted
  • Author

I don't remember exactly but when you highlighted everything and went to insert, You picked a bar and pie graph I seen. Then to get titles you went to LayOut, Chart Title and Axis titles?

Thats basicly it but it doesen't display the info in the way i want it to. Its always some other wrong way.

Link to comment
https://linustechtips.com/topic/364008-excel-graph-how-to-do-it/#findComment-4931394
Share on other sites
Link to post
Share on other sites
Posted

Thats basicly it but it doesen't display the info in the way i want it to. Its always some other wrong way.

How are you trying to get it displayed? Have you tried different types of Bar/Pie Graphics?

 

 

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
https://linustechtips.com/topic/364008-excel-graph-how-to-do-it/#findComment-4931407
Share on other sites
Link to post
Share on other sites
Posted

The order dependes on the way u select it in the table but i cant find the right way.

Highlight part of it and hit CTRL the highlight another part? Now I am confused lol.

 

 

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
https://linustechtips.com/topic/364008-excel-graph-how-to-do-it/#findComment-4931461
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
 Share
Go to topic listing Off Topic

×