Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Chart with multiple plots from VB.NET

Status
Not open for further replies.

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top