ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I set up a stacked chart (https://www.excelbanter.com/charts-charting-excel/168313-how-do-i-set-up-stacked-chart.html)

Izzy

How do I set up a stacked chart
 
I have the following data:
Fall 05 Spring 06 Summer 06
Exc Org 48% 56% 44%
Good Org 52% 44% 66%
Exc Med 77% 80% 84%
Good Med 23% 20% 16%

I would like the good percent to stack on top of the exc percent for each
department.

--
Thank you Thank you

Andy Pope

How do I set up a stacked chart
 
Hi,

If you want a cluster/stack chart have a look at the following
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Izzy" wrote in message
...
I have the following data:
Fall 05 Spring 06 Summer 06
Exc Org 48% 56% 44%
Good Org 52% 44% 66%
Exc Med 77% 80% 84%
Good Med 23% 20% 16%

I would like the good percent to stack on top of the exc percent for each
department.

--
Thank you Thank you



Izzy

How do I set up a stacked chart
 
Bless your heart Andy Pope, I figured it would be in the way I set up the data.

--
Thank you Thank you


"Andy Pope" wrote:

Hi,

If you want a cluster/stack chart have a look at the following
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Izzy" wrote in message
...
I have the following data:
Fall 05 Spring 06 Summer 06
Exc Org 48% 56% 44%
Good Org 52% 44% 66%
Exc Med 77% 80% 84%
Good Med 23% 20% 16%

I would like the good percent to stack on top of the exc percent for each
department.

--
Thank you Thank you




All times are GMT +1. The time now is 07:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com