how to create a stacked bar chart

D

Domingo

Defect Code Part No. Defect Qty

206 A 2
221 B 1
221 C 1
221 D 1


I want to dreate a stacked bar graph to show that defct code had 3 defects
total with part number B, C, D all contributing to the total, defect code 206
had a total of 2 wiht part number contributing 2.
 
L

Luke M

You need to rearrange your data like so:
206 221
A 2 ......
B .... 1
C .... 1
D .... 1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Curve fitting with weighted trendline 1
Excel How to create a stacked bar graph 0
Stacked Chart 2
Stacked bar chart with totals - Excel 2003 2
Stacked Bar Chart 1
Stacked bars with textlegends in each stacked bar 7
stacked column chart 4
2 axis chart stacked bar next to bar with line 1

Top