Combine multiple Chart Types

Published on
8,176 Points
2 Endorsements
Last Modified:
Any charted data series can be converted to any chart type, in any combination, so long as you do not attempt to combine 2D and 3D chart types.

Create a chart that displays multiple data series.  A simple line chart will do.  Next, right-click on any one of the charted series and choose "Chart Type" and pick Pie, or Column, or Bar.

You are not stuck with the few prepared charts provided by Excel.  Create your own.


Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Join & Write a Comment

This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month