line chart? add a series?
 

complete newbie so sorry if this is basic

i have managed to write a macro to do all the maths on my data and to
create chart but i am having problems adding the series.
The length of data is variable, but there will be 4series in total all
on the same chart.

when i highlight the data and do it manually it works fine but i just
cant get it to work writing a macro.

would love some help


--
natzdance
------------------------------------------------------------------------
natzdance's Profile: http://www.excelforum.com/member.php...o&userid=21332
View this thread: http://www.excelforum.com/showthread...hreadid=355968

line chart? add a series?
 

John Peltier has some great information on dynamic charting:
http://peltiertech.com/Excel/Charts/...html#DynColCht

"natzdance" wrote in message
...

complete newbie so sorry if this is basic

i have managed to write a macro to do all the maths on my data and to
create chart but i am having problems adding the series.
The length of data is variable, but there will be 4series in total all
on the same chart.

when i highlight the data and do it manually it works fine but i just
cant get it to work writing a macro.

would love some help


--
natzdance
------------------------------------------------------------------------
natzdance's Profile:
http://www.excelforum.com/member.php...o&userid=21332
View this thread: http://www.excelforum.com/showthread...hreadid=355968