D Dayanand New Member Feb 17, 2015 #1 Hi, I wanted to do some compression graphs between months and zones, I could not understand how do I do with multiple Zones and Months. My data is in below format. Thnxs, Daya Attachments Sample_file.xlsx 11.6 KB · Views: 10 Last edited by a moderator: Feb 17, 2015
Hi, I wanted to do some compression graphs between months and zones, I could not understand how do I do with multiple Zones and Months. My data is in below format. Thnxs, Daya
Hui Excel Ninja Staff member Feb 17, 2015 #2 Daya Firstly, Welcome to the Chandoo.org forums Can you please explain what type of chart you want and what you want displayed Even a hand drawn picture will suffice If you want to compare data please explain what you want to compare
Daya Firstly, Welcome to the Chandoo.org forums Can you please explain what type of chart you want and what you want displayed Even a hand drawn picture will suffice If you want to compare data please explain what you want to compare
D Dayanand New Member Feb 17, 2015 #3 Hi Hui, I want to compare data between zones and months but i have a long zone and month list.
Khalid NGO Excel Ninja Feb 17, 2015 #4 Hi Daya, I am sure Sir Hui and others will give you more ideas. Here is my attempt: I think it will be difficult to make comparison with your current layout. It will be easy if you manage all data in one table for numbers and separate table for percentages. See the attached as a start-up or as an idea. Regards, Attachments Sample_file.xlsx 19.1 KB · Views: 9
Hi Daya, I am sure Sir Hui and others will give you more ideas. Here is my attempt: I think it will be difficult to make comparison with your current layout. It will be easy if you manage all data in one table for numbers and separate table for percentages. See the attached as a start-up or as an idea. Regards,