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

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Threads
1,109,453
Messages
5,528,857
Members
409,840
Latest member
priyanshu270
Top