Excel: Adding a Series to a Chart with a Macro

ID: Q24876

The information in this article applies to:

Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0

SUMMARY

A series can be added to a Microsoft Excel chart through a macro by using the FORMULA command function.

For example, to add a series containing the categories of "a" and "b", the values of 12 and 16, and the plot order number of 1, the following macro command can be used:


   =FORMULA("=SERIES(,{""a"",""b""},{12,16},1)")

For additional information about the SERIES and FORMULA functions, see the references below.

REFERENCES

"Microsoft Excel Function Reference," version 4.0, pages 168-169 (FORMULA), page 387 (SERIES)

"Microsoft Excel Function Reference" version 3.0, pages 89-90 (FORMULA), pages 216-217 (SERIES)

"Microsoft Excel Functions and Macros" version 2.2, pages 224-225 (FORMULA), pages 576-577 (SERIES)

Additional query words:

Keywords :
Version :
Platform :
Issue type :