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

Hi,

can you show us a sample of the data. I don't understand how you would be
plotting one row for each chart and yet show three ratios in one chart since
the three ratios are on separate rows? And are you trying to compare two
companies over 3 years?
Finally, as described it doesn't sound like a line chart is the appropriate
type.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"FARAZ QURESHI" wrote:

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