Generating charts in MS Excel using formulae

Originally Posted by akj504

Hi All,

How to generate charts in MS Excel using formulas but not the chart wizard ???

When I click on any chart in excel I can see a formula (=SERIES(..)) in the formula bar. But when I try to generate charts using the same formula in another sheet (with same data) it gives an error. How to do that ?

Thanks in advance,
-AKJ

Hi,

when you click on a data series you see '=Series'
not when you click on a chart.

You can generate a chart using VBA code, but not by formula.

---