woensdag 23 oktober 2013

Excel: Why Not Split the Y-Axis Four Times Or More?

In this example I split the Y-axis into 5 parts. The main principles? I used a 2-D bar combined with data labels to create the Y-axis. I combined this 2-D bar chart in one graph with a stacked column chart. Integrated with this stacked column chart I used line charts to create the X-axis labels.


I already managed to split the Y-axis, but in this example we can do this unlimited times.

Here are the the basic data:

Amount 1 Amount 2 Amount 3 Amount 4 Amount 5
2001 220 200 180 189 258
2002 350 320 290 279 325
2003 250 290 300 312 267
2004 430 400 370 435 345
2005 350 369 167 234 189
2006 456 367 423 367 421

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

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