Christian_Ku
Board Regular
- Joined
- Sep 10, 2007
- Messages
- 102
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 of water from 1-jan to 5-aug. And I have data of a certain compound concentration in that flow in the same time slot (second Y axis). Most convenient would be to give the X-axis all data points from 1-jan to 31-dec and keep adding data to the Y points. However at the start of the year this is inconvenient and gives less accurate graphs (especially when presentation is required in monthly reports etc.).
So now I want to write a macro that adjusts the series data points. I can easily adjust the X data points as these are always from the same column, but this does not count for the Y data points. My question thus is, how can I retrieve the column information from a range used in a series collection?
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 of water from 1-jan to 5-aug. And I have data of a certain compound concentration in that flow in the same time slot (second Y axis). Most convenient would be to give the X-axis all data points from 1-jan to 31-dec and keep adding data to the Y points. However at the start of the year this is inconvenient and gives less accurate graphs (especially when presentation is required in monthly reports etc.).
So now I want to write a macro that adjusts the series data points. I can easily adjust the X data points as these are always from the same column, but this does not count for the Y data points. My question thus is, how can I retrieve the column information from a range used in a series collection?