Hessel de Walle's Blog

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