Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a new row when data present in a column | Excel Discussion (Misc queries) | |||
include in new column only if present in both columns | Excel Worksheet Functions | |||
building list from a column of data | Excel Worksheet Functions | |||
Adding a comment column to an external datasheet | Excel Worksheet Functions | |||
SUM/COUNT column(s) based on specific value present within the column | Excel Worksheet Functions |