Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked column chart wit more than one column in a data point | Charts and Charting in Excel | |||
Needed: Chart that combines clustered column and stacked column types | Charts and Charting in Excel | |||
How to combine stacked column with a cluster column chart? | Charts and Charting in Excel | |||
How can I add a line chart in a stacked column chart style? | Excel Discussion (Misc queries) | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |