turn excel chart into jpeg file

T

Texas Tonie

Hi,
How do you turn an Excel chart in a jpeg file to share via email?

Helpmuch appreciated

Texas Tonie
 
J

JE McGimpsey

Texas Tonie said:
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.
 
C

CyberTaz

What about printing the Chart sheet as a PDF & send that - haven't tried
it... just asking:)
 
J

Jim Gordon MVP

Hi Texas,

Right click (control-click) on the chart. Choose SAVE AS PICTURE, and choose
JPEG as the format.

-Jim


in said:
Hi,
How do you turn an Excel chart in a jpeg file to share via email?

Helpmuch appreciated

Texas Tonie

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 
J

JE McGimpsey

Jim Gordon MVP said:
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).
 
J

Jim Gordon MVP

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


Wow, do I feel stupid now...

I can't remember ever using that (not that I save charts that often).

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 
A

Adam Bailey

Jim Gordon MVP said:
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.
 
S

Stephanie

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
 
C

CyberTaz

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
 
S

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 --
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! :)


CyberTaz said:
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


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

Jim Gordon MVP said:
Hi Texas,

Right click (control-click) on the chart. Choose SAVE AS PICTURE, and choose
JPEG as the format.

-Jim


Quoting from "Texas Tonie" <[email protected]>, in
article (e-mail address removed), on [DATE:

Hi,
How do you turn an Excel chart in a jpeg file to share via email?

Helpmuch appreciated

Texas Tonie

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 
H

Harvey Waxman

Stephanie said:
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! :)


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)
 
C

CyberTaz

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



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! :)


CyberTaz said:
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


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,

Right click (control-click) on the chart. Choose SAVE AS PICTURE, and
choose
JPEG as the format.

-Jim


Quoting from "Texas Tonie" <[email protected]>, in
article (e-mail address removed), on [DATE:

Hi,
How do you turn an Excel chart in a jpeg file to share via email?

Helpmuch appreciated

Texas Tonie

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top