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
|
|||
|
|||
Clustered and Stacked Column Chart
Is it possible in excel 2002 to do a Clustered Column chart but stacked.
So the columns are stacked and clustered Jan - Apr CostsA1 5 dark blue CostsA2 0.5 light blue CostsB1 10 dark green CostsB2 0.5 light green CostsA darkblue with the light blue on the top of the stack - in january CostsB darkgreen with light green on top of the stack - in january I can do it with out the separating out the top 0.5 Lightcolour but how do I do showing the top lightcolour Many thanks Cassie |
#2
|
|||
|
|||
Clustered and Stacked Column Chart
I've written a tutorial showing how to rearrange your data to facilitate
this chart type: http://peltiertech.com/WordPress/clu...column-charts/ - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Cassie" wrote in message ... Is it possible in excel 2002 to do a Clustered Column chart but stacked. So the columns are stacked and clustered Jan - Apr CostsA1 5 dark blue CostsA2 0.5 light blue CostsB1 10 dark green CostsB2 0.5 light green CostsA darkblue with the light blue on the top of the stack - in january CostsB darkgreen with light green on top of the stack - in january I can do it with out the separating out the top 0.5 Lightcolour but how do I do showing the top lightcolour Many thanks Cassie |
Thread Tools | |
Display Modes | |
|
|