Chart For Every Row In Short Period/Easy Manner
I have a wide range like A1:G50. Range B1:D1 displays heading:
Company 1 - 2008 Company 1 - 2007 Company 1 - 2006
and E1:G1 displays the heading:
Company 2 - 2008 Company 2 - 2007 Company 2 - 2006
Now every row of B2:G50 reflects the data while the A2:A50 states the label
of the same like:
Current Ratio
Liquid Ratio
Debt Ratio
etc.
How to make multiple comparative line charts be created, one for each row
comparing both the companies' performance ratios in the chart area for every
year?
Shall be grateful for all your help.
Thanx
--
Best Regards,
FARAZ A. QURESHI
|