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