If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
can it be done?
hello,
is there any way to create a 2d or 3d chart with stacked columns which would display two/three columns of data stacked with two categories for each year? X axis is the years Y axis is the amt Data would be for 1999 two columns bar 1 (shirts) would be stacked for green and blue bar 2 (ties) would be stacked for green and blue i.e. Shirts 1999 2000 green 2 55 blue 1 85 Ties green 2 54 blue 25 23 can someone help. thank you. |
#2
|
|||
|
|||
Try one of the links here to a clustered-stacked column chart:
http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ chartasap wrote: hello, is there any way to create a 2d or 3d chart with stacked columns which would display two/three columns of data stacked with two categories for each year? X axis is the years Y axis is the amt Data would be for 1999 two columns bar 1 (shirts) would be stacked for green and blue bar 2 (ties) would be stacked for green and blue i.e. Shirts 1999 2000 green 2 55 blue 1 85 Ties green 2 54 blue 25 23 can someone help. thank you. |
Thread Tools | |
Display Modes | |
|
|