excel graph with vba
 

hi, i've a problem with an excel macro.
I've a sheet with some data and i want to create a graph in another sheet.
anyone can help and show me some tricks to resolve my problem?

Luca

excel graph with vba
 

Hi
do you need VBA for this?. Why not use the normal charting
functionality?

--
Regards
Frank Kabel
Frankfurt, Germany


Luca wrote:
hi, i've a problem with an excel macro.
I've a sheet with some data and i want to create a graph in another
sheet. anyone can help and show me some tricks to resolve my problem?

Luca

excel graph with vba
 

Start the macro recorder, create your graph in another worksheet based on
the data in the first worksheet, stop the macro recorder.

This will give you a start.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Luca" wrote in message
...
hi, i've a problem with an excel macro.
I've a sheet with some data and i want to create a graph in another sheet.
anyone can help and show me some tricks to resolve my problem?

Luca

excel graph with vba
 

Ciao Luca,

follow this link, suggested to me by Wei-Dong XU

http://peltiertech.com/Excel/ChartsH...html#VBAcharts

It's a good start in understanding and troubleshooting your problems with charts.

Anyway I did'nt actually understand your question. The wizard drives you through 5 steps and the
last one allows you to choose if create an embedded chart on a sheet or a stand alone chart in a
sheet. I think the last choice is what you need,

Alex

Luca wrote:
hi, i've a problem with an excel macro.
I've a sheet with some data and i want to create a graph in another sheet.
anyone can help and show me some tricks to resolve my problem?

Luca