VBA
Go native, and extend what's in the box for out of the box solutions with Excel VBA
monitoring your system as you execute code
How do I get Excel to run a macro without showing all intermediate steps in a calculation? So, after I kick off the macro, there are no changes on the screen until the macro has finished...
How do I handle a chart, where the number of series to be plotted is determined at runtime?
Submitted by Guest on 07/01/2008 in
I’m trying to plot more than one series on a chart, but I will never know in advance how many series’ will need to be plotted at runtime.
I’ve got the code to add the chart and 1st series in Module1.addChart
The problem at the moment is my Module1.addSeries, because there is no active chart. I’ve tried code to activate / select the chart first, but it’s not having it.
I coded it this way, because before addSeries is called, it adds the actual chart, and I thought the chart was still active.
So I figured passing the chartobject as a parameter would be the best bet.
I’ve got the code to add the chart and 1st series in Module1.addChart
The problem at the moment is my Module1.addSeries, because there is no active chart. I’ve tried code to activate / select the chart first, but it’s not having it.
I coded it this way, because before addSeries is called, it adds the actual chart, and I thought the chart was still active.
So I figured passing the chartobject as a parameter would be the best bet.
»
Use Excel's object model to write fast VBA code...
»
- Click to read more
- View full screen
- 6 min 33 sec
