ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Chart (https://www.excelbanter.com/excel-discussion-misc-queries/156046-chart.html)

jenny

Chart
 
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


All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com