Hi all,
I've got a list of 100+ buildings and their annual GHG emissions from 2011-2015. I want to display the annual GHG emission breakdown (gas, electricity, etc.) for the 5 years and all buildings together in one chart. The emissions have to be stacked per year so that they add up to the total annual emission. Accordingly, building 1 would have 5 stacked bars (one for each year from 2011-2015) right next to each other, followed by building 2 (again, 5 stacked bars), etc.
I get the secondary axis thing but it only allows me to display 2 years in one and the same chart. Hope someone can come up with a solution...
Cheers!
I've got a list of 100+ buildings and their annual GHG emissions from 2011-2015. I want to display the annual GHG emission breakdown (gas, electricity, etc.) for the 5 years and all buildings together in one chart. The emissions have to be stacked per year so that they add up to the total annual emission. Accordingly, building 1 would have 5 stacked bars (one for each year from 2011-2015) right next to each other, followed by building 2 (again, 5 stacked bars), etc.
I get the secondary axis thing but it only allows me to display 2 years in one and the same chart. Hope someone can come up with a solution...
Cheers!