seriescollection

If I select a specific point from serie in a chart, I get three parameters: - ElementID, the selected item, in my case, xlSeries - Arg1, the SeriesIndex - Arg2, the PointIndex So, if I want to know the description of the Serie, ? ActiveChart.SeriesCollection(Arg1).Name But, if I want to know...

Hello, I've been working on a macro that can alter the series data of all series in a chart. This is particularly convenient when working with a second Y-axis as excel then ALWAYS uses the total available X-points when less data is available on the Y-points. Example: I have data from a flow...

Hi all! I'm new to the forums and hope I am placing this post in the correct location. I'm having a lot of trouble automating charts from my VB.NET program. I'm simply graphing one series of data as a time series that must maintain its order as the user filters the data, deletes some data...

Great site and learned a lot alreay, thanks! Now I need to create multiple pie charts based on data in tables on many sheets. I need to create the same set of charts, for each sheet separately. I recorded a macro for one sheet, which created following code...

Hi there, I've got the following issue: I'm updating a chart on a worksheet. For this updating, I need to move the data shown in the chart 1 cel down (e.g. first it was C16:C25, next step would be C17:C26). The chart itself has 8 series in it (7 lines, 1 bar). The macro I have takes the formula...

Hello, I have the following code, attempting to change the color of a data point based on a condition. If a certain value in a "named range" (used as source data for the chart) is 2 then the data point should look "green" on the graph. Sub Chrt() Charts.Add ActiveChart.ChartType =...