turn excel chart into jpeg file
|
|
Thread rating:  |
Texas Tonie - 07 Nov 2007 14:59 GMT Hi, How do you turn an Excel chart in a jpeg file to share via email?
Helpmuch appreciated
Texas Tonie
JE McGimpsey - 07 Nov 2007 15:33 GMT > Hi, > How do you turn an Excel chart in a jpeg file to share via email? Does it need to be jpeg? Or can it be another graphics format?
One of the easiest ways to generate charts as either a gif or png graphic is to choose File/Save As Web Page. When you save the file with the name, say, Test.htm, XL will generate (in the same directory) a folder of the same name (e.g., Test), and the chart will be saved as "image001.gif" or "image001.png", depending on your web preference settings (Preferences/General/Web Options/Picture/Allow png format).
Alternatively, you could use the Grab application to produce a .tiff image. If your chart is either on a chart sheet, or is selected, then choosing Capture/Window will capture the chart. Alternatively, choose Capture/Selection and select the area you want to capture. Then use a graphics application like GraphicConverter to convert it to a jpeg if that's what you need.
You could also just use MacOSX's screen capture (CMD-SHIFT-3 for the whole screen, CMD-SHIFT-4 to select the area to capture). Produces a png on your desktop which you can then convert with GraphicConverter.
CyberTaz - 07 Nov 2007 16:31 GMT What about printing the Chart sheet as a PDF & send that - haven't tried it... just asking:-)
 Signature Regards |:>) Bob Jones [MVP] Office:Mac
>> Hi, >> How do you turn an Excel chart in a jpeg file to share via email? [quoted text clipped - 18 lines] > whole screen, CMD-SHIFT-4 to select the area to capture). Produces a png > on your desktop which you can then convert with GraphicConverter. Jim Gordon MVP - 10 Nov 2007 20:10 GMT Hi Texas,
Right click (control-click) on the chart. Choose SAVE AS PICTURE, and choose JPEG as the format.
-Jim
Quoting from "Texas Tonie" <TexasTonie@discussions.microsoft.com>, in article F776746B-7628-4090-8109-4C67854F93D5@microsoft.com, on [DATE:
> Hi, > How do you turn an Excel chart in a jpeg file to share via email? > > Helpmuch appreciated > > Texas Tonie
 Signature Jim Gordon Mac MVP
MVPs are not Microsoft Employees MVP info http://mvp.support.microsoft.com/
JE McGimpsey - 10 Nov 2007 23:54 GMT > Right click (control-click) on the chart. Choose SAVE AS PICTURE, and choose > JPEG as the format. Wow, do I feel stupid now...
I can't remember ever using that (not that I save charts that often).
Jim Gordon MVP - 11 Nov 2007 22:29 GMT Hi,
This is a feature I use frequently because there is a Mac-only aspect to it.
If a chart or graph is in PowerPoint you can control the size and resolution of the resulting saved file. That's critical for publication purposes.
In all Windows versions of office it is possible to only save to 72dpi, which OK for the web but not for real work.
-Jim
Quoting from "JE McGimpsey" <jemcgimpsey@mvps.org>, in article jemcgimpsey-4BB1FF.16543710112007@msnews.microsoft.com, on [DATE:
>> Right click (control-click) on the chart. Choose SAVE AS PICTURE, and choose >> JPEG as the format. > > Wow, do I feel stupid now... > > I can't remember ever using that (not that I save charts that often).
 Signature Jim Gordon Mac MVP
MVPs are not Microsoft Employees MVP info http://mvp.support.microsoft.com/
Adam Bailey - 15 Nov 2007 11:33 GMT > Right click (control-click) on the chart. Choose SAVE AS PICTURE, and choose > JPEG as the format. You can also click on the chart and Copy it to the clipboard, and paste it into an image program. Preview.app has a "New from Clipboard" menu item in the File menu.
 Signature Adam Bailey | Chicago, Illinois adamb@lull.org | Finger/Web for PGP & S/MIME adamkb@aol.com | http://www.lull.org/adam/
Stephanie - 29 Dec 2007 00:45 GMT Jim - I just tried to right click on a very simple ppt chart to convert it to jpeg, and it seemed to work. However, when I tried to import the file into a blog post (I have a blog...), the file just came up black. I mean just a big, black rectangle.
Weird. Any ideas?? Thanks
Stephanie
> Hi Texas, > [quoted text clipped - 12 lines] > > > > Texas Tonie CyberTaz - 29 Dec 2007 12:30 GMT Hi Stephanie -
What happens if you double-click the image file to open it in Preview, iPhoto, etc.... Or use Insert> Picture in a Word doc?
Did you actually *import* the image - if so, how & into what?... Or did you *paste* it? Exactly *where* is it "coming up black"? It isn't really weird... In fact, it's quite common if you used the copy/paste technique.
Further, JPEG is a "fussy" format as there are several varieties, so it may get scrambled on the clipboard or may present a compatibility issue. What happens if you save it as a PNG instead?
Regards |:>) Bob Jones [MVP] Office:Mac
On 12/28/07 7:45 PM, in article A30A97A3-2B67-4AEC-A35B-8BDD343A0B39@microsoft.com, "Stephanie"
> Jim - > I just tried to right click on a very simple ppt chart to convert it to [quoted text clipped - 22 lines] >>> >>> Texas Tonie Stephanie - 29 Dec 2007 19:26 GMT I use wordpress as a blog platform. When you're in wordpress, to drop a graphic into a blog post, you browse as usual -- off the wordpress page -- select and "open" a document anywhere on your PC and just "upload" as usual. My experience is that the only kind of graphic that has loaded properly in the past is a jpeg...
When you upload a graphic while in wordpress, you first see a preview of the graphic -- this is where I could see that the graphic that I had saved as jpeg from a ppt was just coming up black. Grrr! :)
> Hi Stephanie - > [quoted text clipped - 42 lines] > >>> > >>> Texas Tonie Harvey Waxman - 29 Dec 2007 23:57 GMT > I use wordpress as a blog platform. When you're in wordpress, to drop a > graphic into a blog post, you browse as usual -- off the wordpress page -- [quoted text clipped - 5 lines] > graphic -- this is where I could see that the graphic that I had saved as > jpeg from a ppt was just coming up black. Grrr! :) Has anyone suggested just using cmd-shift-4 to snap a picture of the chart? Then using the free "Kunvert" program to convert the pdf to a jpeg. Easy and quick. (http://www.kualosw.com/English/Pages/Kunvert.html)
 Signature Harvey Products makers of Dinghy Dogsâ„¢ The Boater's Best Friend http://www.dinghydogs.com Remove spam to email
Carl Witthoft - 30 Dec 2007 18:18 GMT > > I use wordpress as a blog platform. When you're in wordpress, to drop a > > graphic into a blog post, you browse as usual -- off the wordpress page -- [quoted text clipped - 12 lines] > and > quick. (http://www.kualosw.com/English/Pages/Kunvert.html) Heck, just use Deeper or Onyx or one of those things to make your default screen dump format JPEG.
 Signature Team EM to the rescue! http://www.team-em.com
CyberTaz - 30 Dec 2007 15:57 GMT OK - I missed the "ppt" in your original post and since you posted to the Excel group I had the impression we were discussing a chart created in & saved from an Excel workbook:-)
How was the chart created - in PPt, pasted from another type of file, inserted as an object...? Going on the assumption that the jpeg *is* at fault, this is need-to-know info.
I'm not familiar with the blogging software, so please follow up a bit more here - is it just the _preview_ that displays black or does the final product display that way as well?
Most programs have no problem with the images output this way, but some do. The file may not contain sufficient data for that particular program to display it properly. It may be necessary to open the jpeg in a graphics editor & resave before inserting into the blog doc.
Did you try the suggestions in the first paragraph of my previous post? What were the results?
Regards |:>) Bob Jones [MVP] Office:Mac
On 12/29/07 2:26 PM, in article C886BE93-FF04-4F60-845A-E73C358C00FC@microsoft.com, "Stephanie"
> I use wordpress as a blog platform. When you're in wordpress, to drop a > graphic into a blog post, you browse as usual -- off the wordpress page -- [quoted text clipped - 54 lines] >>>>> >>>>> Texas Tonie
|
|
|