Ask for the column of the datasheet building the present linechart
 

Hi NG,



with ActiveChart.SeriesCollection.Count for example I can get the Number of
Lines in a linechart.

But how can I get the actual columns of the datascheet concerning to
ActiveChart.SeriesCollection(1)?

I want to change the range of rows (1 to i) buliding a chart of for example
5 lines. (Instead of buliding the chart from row 1 to 100 I want to build
the chart of row 200 to 300).

I would be very glad to get some help

Thanks and kind regards
Uli

Ask for the column of the datasheet building the present linechart
 

Hi,

The range is only exposed as part of the .Formula property.
You will need to parse the returned string to get the appropriate bits.

John Walkenbach has posted a class module to do this.
http://spreadsheetpage.com/index.php..._chart_series/

Cheers
Andy

Uli wrote:
Hi NG,



with ActiveChart.SeriesCollection.Count for example I can get the Number of
Lines in a linechart.

But how can I get the actual columns of the datascheet concerning to
ActiveChart.SeriesCollection(1)?

I want to change the range of rows (1 to i) buliding a chart of for example
5 lines. (Instead of buliding the chart from row 1 to 100 I want to build
the chart of row 200 to 300).

I would be very glad to get some help

Thanks and kind regards
Uli



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Ask for the column of the datasheet building the present linechart
 

Thank You very much for Your help!!!


"Andy Pope" schrieb im Newsbeitrag
...
Hi,

The range is only exposed as part of the .Formula property.
You will need to parse the returned string to get the appropriate bits.

John Walkenbach has posted a class module to do this.
http://spreadsheetpage.com/index.php..._chart_series/

Cheers
Andy

Uli wrote:
Hi NG,



with ActiveChart.SeriesCollection.Count for example I can get the Number
of Lines in a linechart.

But how can I get the actual columns of the datascheet concerning to
ActiveChart.SeriesCollection(1)?

I want to change the range of rows (1 to i) buliding a chart of for
example 5 lines. (Instead of buliding the chart from row 1 to 100 I want
to build the chart of row 200 to 300).

I would be very glad to get some help

Thanks and kind regards
Uli

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info