gt;
>>>>> ** **
>>>>>
>>>>> ** **
>>>>>
>>>>> Do you want this ?
>>>>>
>>>>> See the attached sheet.. you can append table
>>>>>
>>>>> ** **
>>>>
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
>>
>>
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
>
>
-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
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:*
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
@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
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
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