Creating Advanced Chart Types
Most complex charts are easy to create. It’s just that the more complex the chart type, the more likely it is to require some specific choices along the way. Once you understand the concepts behind these choices, you can apply them as needed to a variety of chart types.
With that in mind, this section takes you step-by-step through creating two complex chart types. I’ve chosen these two chart types because they so often trip up even confident, experienced Excel users. The first of these, bubble charts, are a built-in chart type. The second, price/volume charts, are combination column and line charts often used in the securities industry.
Bubble Charts
A bubble chart is really just a scatter chart with an extra value ...
Get Advanced Microsoft® Office Documents 2007 Edition Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
