zaterdag 28 september 2013

Excel: double column, double X-axis; first solution

Here are the data, B3:G5:

til 18 til 30 til 50 til 80 til 100
Male 75 80 85 80 70
Female 60 65 70 65 60

I created two names.

Tussen

=5+MAX(Dubbelekolom!$C$4:$G$4)+MAX(Dubbelekolom!$C$5:$G$5)-(Dubbelekolom!$C$4:$G$4)-(Dubbelekolom!$C$5:$G$5)

and

Totaal

=Dubbelekolom!$C$4:$G$4+Dubbelekolom!$C$5:$G$5+Dubbelekolom!Tussen

The two real series (selected from the sheet) in the graph are:

C4:G4 and C5:G5

In between those two I put a name as a series: =Dubbelekolom!Tussen
And as last series: =Dubbelekolom!Totaal

Totaal is linked to the secondary axis and gets an extra X-axis, which I put at the top. As color I chose no color. As to color, the same goes for Tussen.

Both Y-axis should have a maximum of 160 and a minimum of 0. Then I deleted both Y-axis.

And of course, the color of Male should be blue, and Female pink.

Now the graph should look like this:


You can also download the file dubbelekolom.zip through this link:

https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing
Een reactie plaatsen