Clustered and stacked columns at the same time

P

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

Laurence

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
 
L

Laurence

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
 

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

Top