"Please Help Me!!"

  • Thread starter Thread starter ahsohz
  • Start date Start date
A

ahsohz

Hi All,

I need to create the stacked and clustered column. But, i need to have
3 clustered column and each column has to be stacked..(5 different sets
of data..stacked in one column).

It is like the double column except it has 3 column.

Is it possible to do it? Pls help me...
 
Adapt the technique demonstrated by Stephen Bullen at
http://www.bmsltd.co.uk/excel/SBXLPage.asp#Charting in FunChrt4.zip

Assuming the layout below works out, a chart with 3 clustered columns,
each with three stacked values would require the data be laid out as:

a b g c d h e f i
1 2 7
3 4 8
5 6 9

The chart is drawn as a stacked chart specifying the data are in
columns.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top