ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to use just the graphing capabilities of MS Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/2799-how-use-just-graphing-capabilities-ms-excel.html)

Christopher Blue

How to use just the graphing capabilities of MS Excel?
 
Is there a way to use Excel's graphing capability without using most of
Excel itself? Like an embedded object sort of deal?


Frank Kabel

Hi
you could always copy the created graph in another application (e.g. MS
Word) or insert a MS gchart objext directly in another application (e.g.
Powerpoint)

--
Regards
Frank Kabel
Frankfurt, Germany
"Christopher Blue" schrieb im
Newsbeitrag ...
Is there a way to use Excel's graphing capability without using most of
Excel itself? Like an embedded object sort of deal?




Christopher Blue

I understand but I would like to call it from a program. Right now all I can
do is open up an Excel worksheet that has a graph created out of external
data (which my program modifies). It works but it has it's not as nice as
using the graphing function directly.

"Frank Kabel" wrote:

Hi
you could always copy the created graph in another application (e.g. MS
Word) or insert a MS gchart objext directly in another application (e.g.
Powerpoint)

--
Regards
Frank Kabel
Frankfurt, Germany
"Christopher Blue" schrieb im
Newsbeitrag ...
Is there a way to use Excel's graphing capability without using most of
Excel itself? Like an embedded object sort of deal?





Frank Kabel

Hi
for example in MS Word: 'Insert - Object' and choose 'Microsoft Chart Graph'

--
Regards
Frank Kabel
Frankfurt, Germany
"Christopher Blue" schrieb im
Newsbeitrag ...
I understand but I would like to call it from a program. Right now all I
can
do is open up an Excel worksheet that has a graph created out of external
data (which my program modifies). It works but it has it's not as nice as
using the graphing function directly.

"Frank Kabel" wrote:

Hi
you could always copy the created graph in another application (e.g. MS
Word) or insert a MS gchart objext directly in another application (e.g.
Powerpoint)

--
Regards
Frank Kabel
Frankfurt, Germany
"Christopher Blue" schrieb im
Newsbeitrag ...
Is there a way to use Excel's graphing capability without using most of
Excel itself? Like an embedded object sort of deal?







Jon Peltier

Christopher -

using the graphing function directly.


Do you mean using it "manually" from your program? You'd have to insert an Excel
object or MSGraph object into your program. An OLE object opens in a parent
application with the usual menu commands, so the user can "use" it.

To do this automatically from your program, create an Excel object, make the chart,
then copy the chart and insert it into your program.

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

Christopher Blue wrote:

I understand but I would like to call it from a program. Right now all I can
do is open up an Excel worksheet that has a graph created out of external
data (which my program modifies). It works but it has it's not as nice as
using the graphing function directly.

"Frank Kabel" wrote:


Hi
you could always copy the created graph in another application (e.g. MS
Word) or insert a MS gchart objext directly in another application (e.g.
Powerpoint)

--
Regards
Frank Kabel
Frankfurt, Germany
"Christopher Blue" schrieb im
Newsbeitrag ...

Is there a way to use Excel's graphing capability without using most of
Excel itself? Like an embedded object sort of deal?







All times are GMT +1. The time now is 10:00 AM.

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