Share via

stack column does not stack data

Anonymous
2012-09-13T12:48:13+00:00

Hi,

I'm using Excel 2010 to create a stacked column chart, but am having a fundamental issue - not stacking.  Here's the data table.  What's the trick?

Reservoir - Damaged Impeller - Magnet Assembly Heater - Tube/Element Tray - Damaged Reservoir - Fill Cap PCB - Faulty PCB - Sensor Assembly Impeller - Noise Housing - Rear Housing Not Heating - No Defect Found
Reservoir - Damaged - Cracked 11 0 0 0 0 0 0 0 0 0
Reservoir - Damaged - Notes 7 0 0 0 0 0 0 0 0 0
Impeller - Magnet Assembly - Notes 0 8 0 0 0 0 0 0 0 0
Impeller - Magnet Assembly - Stuck 0 1 0 0 0 0 0 0 0 0
Impeller - Magnet Assembly - Weak 0 1 0 0 0 0 0 0 0 0
Heater - Tube/Element - Leakage Current 0 0 1 0 0 0 0 0 0 0
Heater - Tube/Element - Notes 0 0 4 0 0 0 0 0 0 0
Heater - Tube/Element - Out of spec 0 0 5 0 0 0 0 0 0 0
Tray - Damaged - Cracked 0 0 0 3 0 0 0 0 0 0
Tray - Damaged - Notes 0 0 0 5 0 0 0 0 0 0
Reservoir - Fill Cap - Damaged 0 0 0 8 0 0 0 0 0 0
Reservoir - Fill Cap - Leaking 0 0 0 0 2 0 0 0 0 0
Reservoir - Fill Cap - Missing 0 0 0 0 3 0 0 0 0 0
PCB - Faulty - Capacitor 0 0 0 0 2 0 0 0 0 0
PCB - Faulty - Notes 0 0 0 0 0 2 0 0 0 0
PCB - Sensor Assembly - Disconnected 0 0 0 0 0 5 0 0 0 0
PCB - Sensor Assembly - Notes 0 0 0 0 0 0 1 0 0 0
PCB - Sensor Assembly - Out of spec 0 0 0 0 0 0 1 0 0 0
Impeller - Noise - Out of balance 0 0 0 0 0 0 0 6 0 0
Housing - Rear Housing - Cracked 0 0 0 0 0 0 0 0 5 0
Housing - Rear Housing - Notes 0 0 0 0 0 0 0 0 1 0
Not Heating - No Defect Found - Notes 0 0 0 0 0 0 0 0 0 6
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2012-09-13T13:04:00+00:00

    Figured it out -  "Select Data Source", "Switch Row/Column"

    10+ people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-09-13T13:05:48+00:00

    Can you post a sample file on Skydrive (or similar file sharing site) so we can see what you are doing.?  Then tell us where to look. best wishes

    Windows Live Skydrive: http://skydrive.live.com

    MediaFire: http://www.mediafire.com

    FileFactory: http://www.filefactory.com

    FileSavr: http://www.filesavr.com

    FileDropper: http://www.filedropper.com

    RapidShare: http://www.rapidshare.com

    Box.Net: http://www.box.net/files

    0 comments