| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Chart Add Series with VBA
Let's say
chartdepth = "0,1,2,3,4,5,6,7" chartdays = "0,1,2,3,4,5,6,7,8,9" When I execute the following code, the values for .XValues fills in just fine, but the data for .Values just sits at 0. Dim MyNewSrs As Series Set MyNewSrs = ActiveChart.SeriesCollection.NewSeries With MyNewSrs .Name = well_array(k, 2) MsgBox (chartdepth) .Values = Array(chartdepth) .XValues = Array(chartdays) End With Can anyone help me out? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Chart Add Series with VBA
On Jul 3, 1:34 pm, Juan Schwartz wrote:
Let's say chartdepth = "0,1,2,3,4,5,6,7" chartdays = "0,1,2,3,4,5,6,7,8,9" When I execute the following code, the values for .XValues fills in just fine, but the data for .Values just sits at 0. Dim MyNewSrs As Series Set MyNewSrs = ActiveChart.SeriesCollection.NewSeries With MyNewSrs .Name = well_array(k, 2) MsgBox (chartdepth) .Values = Array(chartdepth) .XValues = Array(chartdays) End With Can anyone help me out? Just to add, the "arrays" have the same number of items in each... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Chart Add Series with VBA
On Jul 3, 1:36 pm, Juan Schwartz wrote:
On Jul 3, 1:34 pm, Juan Schwartz wrote: Let's say chartdepth = "0,1,2,3,4,5,6,7" chartdays = "0,1,2,3,4,5,6,7,8,9" When I execute the following code, the values for .XValues fills in just fine, but the data for .Values just sits at 0. Dim MyNewSrs As Series Set MyNewSrs = ActiveChart.SeriesCollection.NewSeries With MyNewSrs .Name = well_array(k, 2) MsgBox (chartdepth) .Values = Array(chartdepth) .XValues = Array(chartdays) End With Can anyone help me out? Just to add, the "arrays" have the same number of items in each... Figured it out... you just don't put ARRAY() around the vars chartdepth = "0,1,2,3,4,5,6,7" chartdays = "2,3,4,5,6,7,8,9" Dim MyNewSrs As Series Set MyNewSrs = ActiveChart.SeriesCollection.NewSeries With MyNewSrs .Name = well_array(k, 2) MsgBox (chartdepth) .Values = Array(chartdepth) .XValues = Array(chartdays) End With |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel chart maximum series should more than 255 series | Charts and Charting in Excel | |||
| User Selectable Series and Number of Series for Line Chart | Charts and Charting in Excel | |||
| how to plot column chart with one series against multiple series. | Charts and Charting in Excel | |||
| Add Series to a chart failure and Disappearing Series | Excel Programming | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
Hybrid Mode
