Can Chart display 2 year at a time in attached sheet

**sumonrezadu** · 03-23-2012, 08:51 PM

I can see graph of two different zone, but I want to see two different year for the same zone at a time. If I select same zone from both drop down list it is showing single graph for a single year. Can I compare this single graph (i.e for one zone) with two different year at a time (not later by choosing option). I think check box rather than option button may help.

I also require a Message Box when I select zone. How can I have graph, picture (which is solved) and a Message by selecting a zone from list?

Is there any helping hand to solve this problem? Waiting to give a heartfelt thank.

Thx for having patience to read this out.

**FDibbins** · 03-23-2012, 09:02 PM

If you select B23-M23, hold the ctrl key and select C23-M23, this will give you both rows of data in 1 line on the graph...is that what you want?

**sumonrezadu** · 03-23-2012, 10:30 PM

Thanks for your quick reply. Actually what I want for example, what is graph of Dhaka zone in 2010-11 and 2011-12? Now it is seen separately when I choose option 2010-11, graph of 2011-12 can't be seen. Is there any way out that two line for 2010-11 and 2011-12 for Dhaka zone can be seen at a glance?

Now in case 2010-11, Dhaka Vs East can be displayed but in case Dhaka only, can 2010-11 Vs 2011-12 be displayed? My boss wants to see the same chart Zone Vs Zone in single year and later Year Vs Year for single zone in my attached sheet.

Thanks

**FDibbins** · 03-25-2012, 05:24 PM

Very nice system you have there. One way around your problem might be to add a selection for "year", next to your selection for "Zone" That way, you could select Dhaka for both zones, and specify which years you want?

**sumonrezadu** · 03-26-2012, 02:02 PM

Thx for appreciation. I have solved the problem. yes your your guideline helped me. I solved the problem in a different way, not exactly what I wanted i.e not in the same chart but in another chart beside the earlier chart.

Thx again