| 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? |
| 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 | |||
Threaded Mode
