Combination Chart

CindyA

Board Regular
Joined
May 1, 2002
Messages
102
I have 4 numbers to chart which I would like to have the format of 3 different chart types in one chart. Is a way to do this? Here's the example:

Month Total 100 (this would be a bar chart)
Good parts 50 (this would be a stacked bar chart to be teamed with the 'bad parts')
Bad Parts 30 (this would be a stacked bar charat to be teamed with 'good parts')
Goal 110 (this would be a line chart)

The idea is to have the Month total next to the 2 stacked items of good and bad parts. I have easily found a way to change chart types for single numbers but am not sure the option of combining 2 of the 4 items into its own separate bar is possible. Any help would be appreciated.

Thanks in advance.
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Watch MrExcel Video

Forum statistics

Threads
1,114,072
Messages
5,545,822
Members
410,707
Latest member
SanTrapGamer
Top