Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a worksheet with data on it such that I want to graph Column A vs
Column B, Column D vs Column E, Column G vs Column H, etc, etc, scatterplot style. I've already written procedures that determine exactly which cells are to be included. I tried to create the graph manually while recording the code generation in a macro and using that as a guide, but when adding new series to the scatterplot, 'Dim aSeries As Series 'Set aSeries = ActiveChart.SeriesCollection.NewSeries wouldn't allow me to modify the aSeries.Name, .XValues, or .Values properties. So instead of using SeriesCollection.NewSeries(), I'm trying SeriesCollection.Add(): ActiveChart.SeriesCollection.Add Source:=dataSheet.Range(determineDoubleRange(colum n)) My function, determineDoubleRange(column)), returns something like "D15:E40" But instead of Plotting Column D vs E like I want, it's creating two series: D vs A, and E vs A. Any guidance would be greatly appreciated. Thanks in advance. -- ThatFella |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to plot column chart with one series against multiple series. | Charts and Charting in Excel | |||
How do I plot multiple series on one graph? - test-graph.xls (0/1) | Charts and Charting in Excel | |||
How do I plot multiple series on one graph? - test-graph.xls (1/1) | Charts and Charting in Excel | |||
How do you set all graph data points to black (multiple series)? | Charts and Charting in Excel | |||
series graph -- one series being added to another series | Charts and Charting in Excel |