<div>
<div class="content wysiwyg-content">
There is a line chart with &quot;Chart data range&quot; of : 
 
ActiveSheet.ChartObjects(&quot;Chart 1&quot;).Activate 
ActiveChart.SeriesCollection(1).Select 
ActiveChart.SetSourceData Source:=Range(&quot;$D$1:$AA$1&quot;) 
 
I want to add a 2nd dynamic series to this &quot;Chart data range&quot;. 
 
The second set will have values like: 
 
0, 0, 0, 0, 10, 0, 0,0,0,0,....0 
^--col1 &nbsp; &nbsp; &nbsp; ^--col 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;^-- col24 
 
D to AA are 24 columns. I am trying not having these zeros and 10 on the worksheet rather to be fed as digits if possible at all. 
 
Question: How can amend the new series composed of zeros and another non zero number in the mix without having them typed on a worksheet? 
 
 
Thank you.
</div>
</div>

There is a line chart with "Chart data range" of :

ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Select
ActiveChart.SetSourceData Source:=Range("$D$1:$AA$1")

I want to add a 2nd dynamic series to this "Chart data range".

The second set will have values like:

0, 0, 0, 0, 10, 0, 0,0,0,0,....0
^--col1       ^--col 5            ^-- col24

D to AA are 24 columns. I am trying not having these zeros and 10 on the worksheet rather to be fed as digits if possible at all.

Question: How can amend the new series composed of zeros and another non zero number in the mix without having them typed on a worksheet?


Thank you.

Dynamic chart data source...

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.