<

Combine multiple Chart Types

Published on
8,411 Points
5,211 Views
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.

combination.jpg
2
Ask questions about what you read
If you have a question about something within an article, you can receive help directly from the article author. Experts Exchange article authors are available to answer questions and further the discussion.
Get 7 days free