Thread: Problem with creating chart within existing worksheet.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_443_] Leith Ross[_443_] is offline
external usenet poster
  
Posts: 1
Default Problem with creating chart within existing worksheet.

Hello 3PhaseMacroMan,

Unless your system is different, SeriesCollection is a method that
requires an index arugument...

EXAMPLE 1:
..SeriesCollection(1)

This returns a single series. To return all the seiries in a chart
use...

EXAMPLE 2:
..SeriesCollection

If NewSeries is a numeric index then use example 1.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=497003

Reply With QuoteReply With Quote