Stacked Column Chart
 

I have Excel 2003, and I am working with charts. I am not sure how to
interpret the stacked column chart. For example, my January sales column is
divided into three colors: Blue (for Jane), Red (for Joe), and Yellow (for
Betty). The Blue portion of the column stretches from 0% to 40%; the Red
portion of the column stretches stretches from 40% to 65%; and the Yellow
portion of the column stretches from 65% to 100%. I interpreted this to mean
that Blue (Jane) was responsible for 40% of the total sales for January; Red
(Joe) was responsible for 25% of the total sales for January; and that Yellow
(Betty) was responsible for 35% of lthe total sales for January. Is this
interpretation correct?

Thank you for any help you can give me.

Stacked Column Chart
 

probably. check the input value and if it doesn't total 100% then you are
correct
I woul dplay with the chart type while lokking at the data to be surre
whiich chart you are in.

"jfg" wrote:

I have Excel 2003, and I am working with charts. I am not sure how to
interpret the stacked column chart. For example, my January sales column is
divided into three colors: Blue (for Jane), Red (for Joe), and Yellow (for
Betty). The Blue portion of the column stretches from 0% to 40%; the Red
portion of the column stretches stretches from 40% to 65%; and the Yellow
portion of the column stretches from 65% to 100%. I interpreted this to mean
that Blue (Jane) was responsible for 40% of the total sales for January; Red
(Joe) was responsible for 25% of the total sales for January; and that Yellow
(Betty) was responsible for 35% of lthe total sales for January. Is this
interpretation correct?

Thank you for any help you can give me.

Stacked Column Chart
 

Hi,

For more information, please refer to this link.

http://peltiertech.com/Excel/Charts/Combocharts.html

Challa Prabhu

"jfg" wrote:

I have Excel 2003, and I am working with charts. I am not sure how to
interpret the stacked column chart. For example, my January sales column is
divided into three colors: Blue (for Jane), Red (for Joe), and Yellow (for
Betty). The Blue portion of the column stretches from 0% to 40%; the Red
portion of the column stretches stretches from 40% to 65%; and the Yellow
portion of the column stretches from 65% to 100%. I interpreted this to mean
that Blue (Jane) was responsible for 40% of the total sales for January; Red
(Joe) was responsible for 25% of the total sales for January; and that Yellow
(Betty) was responsible for 35% of lthe total sales for January. Is this
interpretation correct?

Thank you for any help you can give me.

Stacked Column Chart
 

Thank you, bj.

"bj" wrote:

probably. check the input value and if it doesn't total 100% then you are
correct
I woul dplay with the chart type while lokking at the data to be surre
whiich chart you are in.

"jfg" wrote:

I have Excel 2003, and I am working with charts. I am not sure how to
interpret the stacked column chart. For example, my January sales column is
divided into three colors: Blue (for Jane), Red (for Joe), and Yellow (for
Betty). The Blue portion of the column stretches from 0% to 40%; the Red
portion of the column stretches stretches from 40% to 65%; and the Yellow
portion of the column stretches from 65% to 100%. I interpreted this to mean
that Blue (Jane) was responsible for 40% of the total sales for January; Red
(Joe) was responsible for 25% of the total sales for January; and that Yellow
(Betty) was responsible for 35% of lthe total sales for January. Is this
interpretation correct?

Thank you for any help you can give me.

Stacked Column Chart
 

Thank you, Challa. I clicked on the URL and got the message "This page could
not be displayed." In general, is my interpretation correct?

"challa prabhu" wrote:

Hi,

For more information, please refer to this link.

http://peltiertech.com/Excel/Charts/Combocharts.html

Challa Prabhu

"jfg" wrote:

I have Excel 2003, and I am working with charts. I am not sure how to
interpret the stacked column chart. For example, my January sales column is
divided into three colors: Blue (for Jane), Red (for Joe), and Yellow (for
Betty). The Blue portion of the column stretches from 0% to 40%; the Red
portion of the column stretches stretches from 40% to 65%; and the Yellow
portion of the column stretches from 65% to 100%. I interpreted this to mean
that Blue (Jane) was responsible for 40% of the total sales for January; Red
(Joe) was responsible for 25% of the total sales for January; and that Yellow
(Betty) was responsible for 35% of lthe total sales for January. Is this
interpretation correct?

Thank you for any help you can give me.

Stacked Column Chart
 

The proper link is case sensitive:

http://peltiertech.com/Excel/Charts/ComboCharts.html

but I'm not sure why that particular page is relevant. Anyway, it sounds
like your interpretation of the chart was correct.

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


"jfg" wrote in message
...
Thank you, Challa. I clicked on the URL and got the message "This page
could
not be displayed." In general, is my interpretation correct?

"challa prabhu" wrote:

Hi,

For more information, please refer to this link.

http://peltiertech.com/Excel/Charts/Combocharts.html

Challa Prabhu

"jfg" wrote:

I have Excel 2003, and I am working with charts. I am not sure how to
interpret the stacked column chart. For example, my January sales
column is
divided into three colors: Blue (for Jane), Red (for Joe), and Yellow
(for
Betty). The Blue portion of the column stretches from 0% to 40%; the
Red
portion of the column stretches stretches from 40% to 65%; and the
Yellow
portion of the column stretches from 65% to 100%. I interpreted this to
mean
that Blue (Jane) was responsible for 40% of the total sales for
January; Red
(Joe) was responsible for 25% of the total sales for January; and that
Yellow
(Betty) was responsible for 35% of lthe total sales for January. Is
this
interpretation correct?

Thank you for any help you can give me.

Stacked Column Chart
 

Thankyou for correcting. I never knew it was case sensitive. Its my favourite
link Peltier. I learned a lot myself. Thanks once again.

Challa Prabhu

"Jon Peltier" wrote:

The proper link is case sensitive:

http://peltiertech.com/Excel/Charts/ComboCharts.html

but I'm not sure why that particular page is relevant. Anyway, it sounds
like your interpretation of the chart was correct.

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


"jfg" wrote in message
...
Thank you, Challa. I clicked on the URL and got the message "This page
could
not be displayed." In general, is my interpretation correct?

"challa prabhu" wrote:

Hi,

For more information, please refer to this link.

http://peltiertech.com/Excel/Charts/Combocharts.html

Challa Prabhu

"jfg" wrote:

I have Excel 2003, and I am working with charts. I am not sure how to
interpret the stacked column chart. For example, my January sales
column is
divided into three colors: Blue (for Jane), Red (for Joe), and Yellow
(for
Betty). The Blue portion of the column stretches from 0% to 40%; the
Red
portion of the column stretches stretches from 40% to 65%; and the
Yellow
portion of the column stretches from 65% to 100%. I interpreted this to
mean
that Blue (Jane) was responsible for 40% of the total sales for
January; Red
(Joe) was responsible for 25% of the total sales for January; and that
Yellow
(Betty) was responsible for 35% of lthe total sales for January. Is
this
interpretation correct?

Thank you for any help you can give me.