Clustered and stacked columns at the same time

[Patrick]

Hi,

I have a series of data that I would like to be
represented on a single chart in clustered and stacked
columns. I will explain in details the situation.

I have sales data for the 4 regions, viz. North, East,
West South. The data is additionally categorized across
hardware sales and software sales.

These data are grouped per month.

Thus, I have a matrix as follows for each region:

Period Hardware Sales Software Sales
Jan xxx yyy
Feb aaa bbb
Mar ppp qqq
....
....

What I wanted was to have a chart where the x asix is the
timeline (=months).

Per month, I wanted the data for each region and category
(hard + soft) to be displayed in stacked columns. Thus,
for North I have a stacked column, for South I have a
stacked column and so on.

Each of these 4 stacked columns are then represented next
to each other as clustered column so that I can easily
visualize the details per month.

I hope that I have explained my requirement clearly. And
now for some real chart wizards to come up with a solution.

Thanks for your help in advance,

Pat.

 

[Tushar Mehta]

Visit Stephen Bullen's
http://www.bmsltd.co.uk/excel/SBXLPage.asp#Charting and check out
FunChrt4.zip.

--
Regards,

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

 

[Guest]

Patrick
I have the same kind of problem
If you fnd a way to process pls inform me
rgds
Laurenc


----- Patrick wrote: ----

Hi

I have a series of data that I would like to be
represented on a single chart in clustered and stacked
columns. I will explain in details the situation

I have sales data for the 4 regions, viz. North, East,
West South. The data is additionally categorized across
hardware sales and software sales

These data are grouped per month

Thus, I have a matrix as follows for each region

Period Hardware Sales Software Sale
Jan xxx yy
Feb aaa bb
Mar ppp qq
...
...

What I wanted was to have a chart where the x asix is the
timeline (=months)

Per month, I wanted the data for each region and category
(hard + soft) to be displayed in stacked columns. Thus,
for North I have a stacked column, for South I have a
stacked column and so on

Each of these 4 stacked columns are then represented next
to each other as clustered column so that I can easily
visualize the details per month

I hope that I have explained my requirement clearly. And
now for some real chart wizards to come up with a solution

Thanks for your help in advance

Pat

 

[Guest]

Dear Tushar
I saw your example file. It responds exactly on what I want to do
But your short explaination are not sufficient for me to understand how to create such chart
Could you pls explain in more details
rgds
Laurenc
----- Tushar Mehta wrote: ----

Visit Stephen Bullen's
http://www.bmsltd.co.uk/excel/SBXLPage.asp#Charting and check out
FunChrt4.zip

--
Regards

Tushar Mehta, MS MVP -- Exce
www.tushar-mehta.co
Excel, PowerPoint, and VBA add-ins, tutorial
Custom MS Office productivity solution

 

[Debra Dalgleish]

Bernard Liengme has an example and instructions on his site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

and the following MSKB article has an example:
XL2000: Creating Charts with Multiple Groups of Stacked Bars
http://support.microsoft.com/default.aspx?id=214119

 

[Guest]

thanks a lot
rgds
Laurenc