Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple series on a graph
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple series on a graph
What line gave the error, and what was the error? Did you have the
apostrophes in front of the Dim and Set lines in the code, or only in the message you posted? - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ ThatFella wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple series on a graph
Jon Peltier wrote:
*What line gave the error, and what was the error? Did you have the apostrophes in front of the Dim and Set lines in the code, or only in the message you posted? - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ * Thank you guys for the responses. Very shortly after posting this, my code began to work. (I don't recall what I changed or even if I actually knew what I changed). Having fixed the problem so soon after posting and seeing that I had not yet received a response, I used the "delete post" button offered by this web-based ng reader that I use. The thread was deleted off of this web-based reader, but I guess the feature doesn't work as well as it led me to believe. I only now found your responses because I did a search for "ThatFella" to find another post of mine. I apologize. Next time I shall just reply to the message explaining that I've resolved the issue and how I did it. Thanks again for the responses. BTW, the apostrophe's were definately NOT in my code. ;) -- ThatFella |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple series on a graph
Very shortly after posting this, my code began to work.
Happens all the time! The send button works wonders. Next time I shall just reply to the message explaining that I've resolved the issue and how I did it. That might be handy, especially if someone else is having the same issue. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ ThatFella wrote: Jon Peltier wrote: *What line gave the error, and what was the error? Did you have the apostrophes in front of the Dim and Set lines in the code, or only in the message you posted? - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ * Thank you guys for the responses. Very shortly after posting this, my code began to work. (I don't recall what I changed or even if I actually knew what I changed). Having fixed the problem so soon after posting and seeing that I had not yet received a response, I used the "delete post" button offered by this web-based ng reader that I use. The thread was deleted off of this web-based reader, but I guess the feature doesn't work as well as it led me to believe. I only now found your responses because I did a search for "ThatFella" to find another post of mine. I apologize. Next time I shall just reply to the message explaining that I've resolved the issue and how I did it. Thanks again for the responses. BTW, the apostrophe's were definately NOT in my code. ;) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |