donderdag 3 oktober 2013

Excel: double column, double X-axis; second solution and a lot easier

Another solution to the double column, double X-axis and a lot simpler.

Here are the data, from B3:G5:

til 18 til 25 til 40 til 65 til 85
Male 75 80 85 80 70
Female 60 65 70 65 60

  • Now create a simple column graph.
  • Link the female columns to the secondary axis.
  • For both Y-axis you now have, pick a minimum of 0 and a maximum of 200.
  • For the seconday Y-axis choose Values in reverse order.
  • Add a seconday X-axis.
For some reasons the graph changes now to something we do'nt want. Both columns start at the bottom.
  • Change the secondary Y-axis, Horizontal axis crosses to automatic.
Then we get this graph:

You can also download the file through this link:
Een reactie posten