ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro to export a graph from Excel into Power Point (https://www.excelbanter.com/excel-programming/385647-macro-export-graph-excel-into-power-point.html)

JB

Macro to export a graph from Excel into Power Point
 
Does anyone know how to create a macro or program that will export a graph
from Excel into Power Point?

Thanks,



Jon Peltier

Macro to export a graph from Excel into Power Point
 
http://peltiertech.com/Excel/XL_PPT.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"jb" wrote in message
...
Does anyone know how to create a macro or program that will export a graph
from Excel into Power Point?

Thanks,





JB

Macro to export a graph from Excel into Power Point
 
Hi Jon,

Thanks for responding to my post the other day. I found your writeup on
this incredibly helpful and interesting as it told me what kinds of problems
I may run into and how to deal with them. Very much appreciate the support.

I've just done some of what you've advised, and what I found is that when I
copy one of the graphs I'm trying to move over as a picture, part of the
chart title (the one for the left Y axis) does NOT come accross. If I copy
it regularly, it does. Based on your description of the difference, I
definitely would like to copy it over as a picture, but I'm not sure how to
do that without loosing part of the chart titles. Any ideas?

Thanks,

Jb

"Jon Peltier" wrote:

http://peltiertech.com/Excel/XL_PPT.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"jb" wrote in message
...
Does anyone know how to create a macro or program that will export a graph
from Excel into Power Point?

Thanks,






Jon Peltier

Macro to export a graph from Excel into Power Point
 
I know I say in the web page to use the On Screen settings, but the Y Axis
Title truncation is an on-screen problem, but not a printing problem. Try
the Printed settings instead.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"jb" wrote in message
...
Hi Jon,

Thanks for responding to my post the other day. I found your writeup on
this incredibly helpful and interesting as it told me what kinds of
problems
I may run into and how to deal with them. Very much appreciate the
support.

I've just done some of what you've advised, and what I found is that when
I
copy one of the graphs I'm trying to move over as a picture, part of the
chart title (the one for the left Y axis) does NOT come accross. If I
copy
it regularly, it does. Based on your description of the difference, I
definitely would like to copy it over as a picture, but I'm not sure how
to
do that without loosing part of the chart titles. Any ideas?

Thanks,

Jb

"Jon Peltier" wrote:

http://peltiertech.com/Excel/XL_PPT.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"jb" wrote in message
...
Does anyone know how to create a macro or program that will export a
graph
from Excel into Power Point?

Thanks,









All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com