• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 27. Advanced Charting Techniques > Using Named Ranges to Create Dynamic...

Using Named Ranges to Create Dynamic Charts

If you select a chart's series and look at Excel's formula line, you see that a series is generated by a formula that uses the SERIES function. SERIES is a special kind of function that's used only in this context, to define a chart series. You can't use it on the worksheet, and you can't incorporate worksheet functions or formulas into its arguments.

For all chart types except bubble, the SERIES function has the arguments listed in Table 27-1.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint