excel graph with vba

L

Luca

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
 
R

Rob van Gelder

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.
 
Y

y

Ciao Luca,

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

http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.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
 
Top