J
Jenny
This is hard to explain.
I have 3 tables with the year on year increase for 1BR, 2BR and 3BR flats.
Each table contains the info for 2006, 2007 and the % change from both in the
column part, and the different locations in the row part.
I want to create a chart that compares the 2 years next to each other for
the different locations using stacked columns for the 1BR, 2BR and 3BR. It
should also include 3 lines representing the % change for each commodity
(1BR,...). Now the x-axis should be the different locations, the left y-axis
should be the price and the right y-axis should be the % change.
I'm not sure if explained myself properly. But if anyones understands, can
you please let me know if it's possibel or not?
Thanks
I have 3 tables with the year on year increase for 1BR, 2BR and 3BR flats.
Each table contains the info for 2006, 2007 and the % change from both in the
column part, and the different locations in the row part.
I want to create a chart that compares the 2 years next to each other for
the different locations using stacked columns for the 1BR, 2BR and 3BR. It
should also include 3 lines representing the % change for each commodity
(1BR,...). Now the x-axis should be the different locations, the left y-axis
should be the price and the right y-axis should be the % change.
I'm not sure if explained myself properly. But if anyones understands, can
you please let me know if it's possibel or not?
Thanks