Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help setting chart series values with non-continuous range
I am trying to create a chart with multiple series and each series having
values from non-continuous ranges. Can someone help by explaining why this doesn't work or what I should do instead. Charts.Add ActiveChart.ChartType = xlLineMarkers With ActiveChart.SeriesCollection.NewSeries .Name = Worksheets("Review").Cells(vX, 2) .Values = Union(Range(Worksheets("Review").Cells(11, 7), Worksheets("Review").Cells(11, 24)), Range(Worksheets("Review").Cells(50, 25), Worksheets("Review").Cells(50, 61))) End With I found the Uniton on this forum and it works for ActiveChart.SetSourceData Source:= But I need to do multiple series. Thanks, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named range not continuous. How to display values? | Excel Worksheet Functions | |||
VBA - Setting up a Chart series | Excel Discussion (Misc queries) | |||
Read series values range of a chart | Charts and Charting in Excel | |||
Setting Excel chart series from vb6 | Charts and Charting in Excel | |||
Setting Chart series | Excel Programming |