Re: $$Excel-Macros$$ drawing chart based on the given data

2012-07-07 Thread Sandeep Kumar Baranwal
gt; >>>>> ** ** >>>>> >>>>> ** ** >>>>> >>>>> Do you want this ? >>>>> >>>>> See the attached sheet.. you can append table >>>>> >>>>> ** ** >>>>

Re: $$Excel-Macros$$ drawing chart based on the given data

2012-07-06 Thread ashish koul
s* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Sandeep Kumar Baranwal >> *Sent:* 06 July 2012 10:21 >> >>

Re: $$Excel-Macros$$ drawing chart based on the given data

2012-07-06 Thread Sandeep Kumar Baranwal
m [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Sandeep Kumar Baranwal > *Sent:* 06 July 2012 10:21 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ drawing chart based on the given data > > ** ** > > Respected Rajan Sir > >

RE: $$Excel-Macros$$ drawing chart based on the given data

2012-07-06 Thread Rajan_Verma
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sandeep Kumar Baranwal Sent: 06 July 2012 10:21 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ drawing chart based on the given data Respected Rajan Sir I am not able to locate the related VBA code in

Re: $$Excel-Macros$$ drawing chart based on the given data

2012-07-06 Thread ashish koul
gt;> *+91 7838100659 [IM-Gtalk]* >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Sandeep Kumar Baranwal >> *Sent:* 06 July 2012 8:51 >> *To:* excel-macros@googlegroups.com >> *Subject:*

Re: $$Excel-Macros$$ drawing chart based on the given data

2012-07-06 Thread Sandeep Kumar Baranwal
macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Sandeep Kumar Baranwal > *Sent:* 06 July 2012 8:51 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ drawing chart based on the given data > > ** ** > > Respected Rajan Si

RE: $$Excel-Macros$$ drawing chart based on the given data

2012-07-06 Thread Rajan_Verma
@googlegroups.com Subject: Re: $$Excel-Macros$$ drawing chart based on the given data Respected Rajan Sir thanks a lot for the quick response. However, my requirement is to draw two graphs in one chart itself: 1) year (along x-axis) versus age (along y-axis (primary axis))) and 2) year (along x

Re: $$Excel-Macros$$ drawing chart based on the given data

2012-07-06 Thread Sandeep Kumar Baranwal
Respected Rajan Sir thanks a lot for the quick response. However, my requirement is to draw two graphs in one chart itself: 1) year (along x-axis) versus age (along y-axis (primary axis))) and 2) year (along x-axis) versus salary (along y-axis (secondary axis)) and the chart must incorporate ever

RE: $$Excel-Macros$$ drawing chart based on the given data

2012-07-06 Thread Rajan_Verma
Use this: Sub MakeChart() Dim wksSheet As Worksheet Dim chtChart As Chart Set wksSheet = Sheet1 Set chtChart = wksSheet.Shapes.AddChart(xlBar, 200, 200, 600, 200).Chart chtChart.SetSourceData Range("A1").CurrentRegion End Sub Regards Rajan ver