Question:
Yahoo Answers Global Warming and Microsoft Excel: How do you post the second on the first?
anonymous
1970-01-01 00:00:00 UTC
Yahoo Answers Global Warming and Microsoft Excel: How do you post the second on the first?
Seven answers:
david b
2010-12-03 14:59:03 UTC
I don't use flikr or photobucket or any other photo sharing site so I might not be that helpful, but here goes,



I'm assuming you're on a PC - but you could make the graph or section of the spread sheet you want to share large on the screen, press the print screen button (typically above the Delete and Insert buttons). Then open up the Paint program in the Accessories folder under the start menu and paste (Ctrl+V). An image of you screen should be pasted into Paint from which you can crop and then save the file as a .jpg, .bmp or some other image format for uploading to a file sharing website.



Here's a wiki-how on doing the same thing in case any part of my explanation is confusing



http://www.wikihow.com/Take-a-Screenshot-in-Microsoft-Windows



Also I haven't used it much, but google has spreadsheets that can be shared. I have no idea how their graphing abilities go, if they're even available.



http://spreadsheets.about.com/od/tipsandfaqs/qt/share_google.htm



Good Luck!



EDIT - I just checked out Google Spreadsheets and it looks like there are several options for producing figures, with the ability to generate a URL that goes directly to the spreadsheet and graph, this might be your best bet.



EDIT for Jim Z - I think the problem you're talking about is in copying data from an online space delimited source into excel columns? Pasting the data in and then going "data" section of the ribbon in Excel, click "text to columns," click "delimited" and then the manner in which the data is delimited - be it space, comma, tab.
JimZ
2010-12-03 15:33:11 UTC
I ended up just typing in them in manually last time I worked on it. Once in your spreadsheet you have it but it is tedious. I have not been able to figure out how to transfer the data from NASA or Mauna Loa. I believe I remember Trevor (I think) claimed he had a method to transfer that data but maybe he wasn't transferring to Excel. I will look back and see if there are good suggestions. Obviously mine is a last resort.
bob326
2010-12-03 18:40:02 UTC
Save the graph as a jpg or gif and upload to tinypic.com. The site will provide a url for your picture and you can then post it here. Or you could try setting up a free blog with wordpress.com simply for your graphs/figures, upload your pics to a blogpost, and then post a link.



I agree with Trevor in that Excel is fairly limited in its graphing abilities, and my personal preference is a statistical software like R, which is free to download, contains countless tools for data analysis, but which has a steeper learning curve than Excel.



Jim,

Try saving the datapage as a txt file. Open up an excel worksheet, go to the "Data" tab, "Get External Data", and "Import Text File". You can mess around with the starting line, field separation type, etc. This is all in excel 2004, but I assume newer/older versions are similar.
A Modest Proposal
2010-12-03 17:16:03 UTC
That's actually a good question, and if anyone has suggestions on how it might work for a Mac, if it's at all different, that'd be great.



Edit: Sorry Rio for the delay, haven't been checking back on here.



I haven't done any work with Linux or unix. I'm rather computer illiterate when it comes to software. I do like my Mac though, despite how it's a Mac mini and isn't as nice as the larger computers Apple sells.
Rio
2010-12-03 16:49:42 UTC
Onenote or snipit both can be hyper linked. Excel should also have a send as/save as prompt, but you have to chose the right format, for printing, html, rich text,..etc. Most of time I open both windows cut & paste then drag & drop. Win 7 seems to able to bypasses the cut & paste. Yahoo doesn't accept every format and I have had problems with it if its not in html. Still learning myself



Edit: Run a few trail examples on YA till you get it down. We will know what you trying to do. No big deal.



Edit2: AMP, must be nice. I'd give my left nut to depart from Windows OS. I think if I ever get the spare time I'll try to learn linux on some of my old clunkers laying about. Have you tried any open sourced programs that caters to unix systems?
hickman
2016-10-04 08:17:04 UTC
One that article is over a yr historical and 2 you fully ignored the factor. No one is arguing the the international local weather does not difference, the argument is that it's Anthropogenic, guy prompted if you'll. So from the Fox News file, "...part of Democrats suppose human habits is the intent of international warming (fifty two percentage) in comparison to 30 percentage of Republicans." Please attempt to hold up with the area to hand, and in the event you cannot hold up probably you should not be attempting to take action. BTW, This file could point out that final yr at nice probably part of Americans believed in AGW. I'd certain like to look an up to date ballot .
Trevor
2010-12-03 17:50:30 UTC
I guess that the easiest way to do that would be…



• Input your data into the Excel Spreadsheet as normal



• Create the graphs that you require



• Save the spreadsheet – click on , then from the drop down box for choose , click Save.



• The spreadsheet will be saved as an HTML file and all the graphics as GIF files. You’ll find that in the folder you chose to save the file to, that a sub-folder will have been created with the same name as you gave the spreadsheet, that’s where your images will be.



Excel is quite limiting when it comes to creating graphs but you can create your image as described above then open it with photo-editing software and add graphics etc as desired.



Flickr will support GIF file formats but it is more restricted than other image hosts, images sizes are limited to a max of about 950 x 600 pixels (upload a larger image and it will be reduced in size) and it supports less file types. I’ve found that ImageShack (www.imageshack.us) gets round these problems.



The above will enable you to create and share basic graphics. Some of the more complex ones I’ve created and linked to in the past used Net CDF and adapted spreadsheet software like this http://www.flickr.com/photos/trevorandclaire/5005644802/sizes/l/in/photostream/ but the standard ones like this http://www.flickr.com/photos/trevorandclaire/4973927293/sizes/l/in/photostream/ were created in Excel, saved as a GIF and uploaded as-is.


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...