Good afternoon!
I am looking to make a bar chart with 2 data categories.

Generalized Error Category
Specific Error Type
then plot the quantity.

I would like to have it all on 1 chart...with each general category shown in
a different color if possible...

So engineering errors would all be blue...with error type 1 having 4
instances..and type 2 having 6 instances then mechanical errors would be
pink with error type 3 having 10 instances.....etc.

I hope that makes sense.

Thank you for any insight you can give!
have a GREAT day!
brenda

Set up your data as shown (view in courier):

Mechanical Electrical Hydraulic
Mechanical Gear 11
Bearing 8
Motor 3
Electrical Switch 19
Plug 12
Cord 11
Fuse 3
Bulb 2
Hydraulic Pump 4
Leak 3
Seals 1

The first two cells in the top row are blank. and all cells in first column
except for main categories are also blank.

Select the data, and create a stacked column chart. Format to suit.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
774-275-0064
208-485-0691 fax

http://PeltierTech.com/
_______


"frendabrenda1" wrote in message
...
Good afternoon!
I am looking to make a bar chart with 2 data categories.

Generalized Error Category
Specific Error Type
then plot the quantity.

I would like to have it all on 1 chart...with each general category shown
in
a different color if possible...

So engineering errors would all be blue...with error type 1 having 4
instances..and type 2 having 6 instances then mechanical errors would be
pink with error type 3 having 10 instances.....etc.

I hope that makes sense.

Thank you for any insight you can give!
have a GREAT day!
brenda

I worked out this example in my blog:

http://peltiertech.com/WordPress/200...category-axis/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jon Peltier" wrote in message
...
Set up your data as shown (view in courier):

Mechanical Electrical Hydraulic
Mechanical Gear 11
Bearing 8
Motor 3
Electrical Switch 19
Plug 12
Cord 11
Fuse 3
Bulb 2
Hydraulic Pump 4
Leak 3
Seals 1

The first two cells in the top row are blank. and all cells in first
column except for main categories are also blank.

Select the data, and create a stacked column chart. Format to suit.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
774-275-0064
208-485-0691 fax

http://PeltierTech.com/
_______


"frendabrenda1" wrote in message
...
Good afternoon!
I am looking to make a bar chart with 2 data categories.

Generalized Error Category
Specific Error Type
then plot the quantity.

I would like to have it all on 1 chart...with each general category shown
in
a different color if possible...

So engineering errors would all be blue...with error type 1 having 4
instances..and type 2 having 6 instances then mechanical errors would be
pink with error type 3 having 10 instances.....etc.

I hope that makes sense.

Thank you for any insight you can give!
have a GREAT day!
brenda