O'Reilly logo

Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond by Reinhold Scheck

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Digression: important Functions and Formulas

In the previous section, I referred to the fact that the formation of a chart basis—i.e., the route taken by the data in steps C through D—is usually organized using formulas. These create a definable extract of the data sources, which can be modified using controls. I therefore will refer to some of the relevant functions, which are called lookup and reference functions in Excel, as extracting functions. We’ll be using the three most important of these soon, so I’ll briefly digress in order to explain this subject. Other functions from the same group will come into play in later chapters.

On the Companion CD

Open the \Samples\0201_Extract.xlsx file on the CD-ROM.

The 0201_Extract.xlsx file contains the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required