"Please Help Me!!"

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...
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stacked Clustered Column? 1
Charting 4
Sorting a stacked column 0
How do I combine stacked and clustered chart types? 2
Clustered-Stacked-Column Combo Chart With Lines 2
How do I create a combined 'cluster' and 'stacked' column chart? 1
Multiple stacked clustered bars 1
How do I add a total to a clustered bar graph 0

Top