GhaniPro
Programmer
- Jun 23, 2004
- 3
Hi,
I have a table such as :
2000 2001 2002
==================
Val11 Val12 Val13
'These values correspond to theme 1 : eg: "Number of beneficiaries"
Val21 Val22 Val23
'These values correspond to theme 2 : eg: "Total loans amount"
Val31 Val32 Val33
'These values correspond to theme 2 : eg: "Number of loans"
I'm exporting the table to an Excel WorkSheet and would like to build 3 plots, one for each theme ("Number of beneficiaries", "Total loans amount", "Number of loans"), on the same Excel chart knowing that the X axis is always (2000, 2002, 2003) for each plot.
How can I achieve this, that is "tell" the chart to use the same X axis but with 3 different data ranges to draw three line plots?
I'd like also the heading (legend) of each plot to be the theme's name : ("Number of beneficiaries", "Total loans amount", "Number of loans").
Thanks
I have a table such as :
2000 2001 2002
==================
Val11 Val12 Val13
'These values correspond to theme 1 : eg: "Number of beneficiaries"
Val21 Val22 Val23
'These values correspond to theme 2 : eg: "Total loans amount"
Val31 Val32 Val33
'These values correspond to theme 2 : eg: "Number of loans"
I'm exporting the table to an Excel WorkSheet and would like to build 3 plots, one for each theme ("Number of beneficiaries", "Total loans amount", "Number of loans"), on the same Excel chart knowing that the X axis is always (2000, 2002, 2003) for each plot.
How can I achieve this, that is "tell" the chart to use the same X axis but with 3 different data ranges to draw three line plots?
I'd like also the heading (legend) of each plot to be the theme's name : ("Number of beneficiaries", "Total loans amount", "Number of loans").
Thanks