Charting Multiple Categories

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

frendabrenda1 - 22 Apr 2008 19:44 GMT

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

Reply to this Message

Jon Peltier - 22 Apr 2008 19:57 GMT

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
jon@peltiertech.com
http://PeltierTech.com/
_______

> Good afternoon!
> I am looking to make a bar chart with 2 data categories.
[quoted text clipped - 16 lines]
> have a GREAT day!
> brenda

Reply to this Message

Jon Peltier - 23 Apr 2008 12:58 GMT

I worked out this example in my blog:

http://peltiertech.com/WordPress/2008/04/22/chart-with-a-dual-category-axis/

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

> Set up your data as shown (view in courier):
>
[quoted text clipped - 46 lines]
>> have a GREAT day!
>> brenda

Reply to this Message