Bar chart with

[Marjo Kasanko]

I have the following problem:

I have 15 cities for which I have two data values for 4
dates (example: Vienna 1950: 10 90
1960: 50 50
1980: 20 80
1990: 60 40)

How to show them in a bar chart so that each city is in x-
axis and all for dates appear on y axis so that two
values are showed as 100 % stacked columns?

Many thanks in advance!

 

[Jon Peltier]

Marjo -

Do the columns with 10 and 90 have names? Then put the names into the
cells above the numbers, and keep the cell above the dates blank.

A B
1950 10 90
1960 50 50
1980 20 80
1990 60 40

Now select all this data, including the years and the labels (A and B),
and make a 100% Stacked Column chart.

- Jon

 

[Andy Pope]

Hi Marjo,

I had a different understanding of your problem to Jon.

I think you need a combination chart, stacked column and a bar to
provide category labels on the Y axis.

Have a look at this example,
(http://www.andypope.info/ngs/ng24.htm)

I have the following problem:

I have 15 cities for which I have two data values for 4
dates (example: Vienna 1950: 10 90
1960: 50 50
1980: 20 80
1990: 60 40)

How to show them in a bar chart so that each city is in x-
axis and all for dates appear on y axis so that two
values are showed as 100 % stacked columns?

Many thanks in advance!

--

Cheers
Andy

http://www.andypope.info