LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to plot column chart with one series against multiple series. svenkateshmurthy Charts and Charting in Excel 2 October 16th 07 09:09 PM
How do I plot multiple series on one graph? - test-graph.xls (0/1) Leo Bueno Charts and Charting in Excel 1 August 2nd 07 12:49 PM
How do I plot multiple series on one graph? - test-graph.xls (1/1) Leo Bueno Charts and Charting in Excel 0 August 2nd 07 12:14 AM
How do you set all graph data points to black (multiple series)? DamnKiwi Charts and Charting in Excel 1 September 1st 05 01:00 PM
series graph -- one series being added to another series rich zielinski via OfficeKB.com Charts and Charting in Excel 3 March 30th 05 06:23 PM


All times are GMT +1. The time now is 06:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"