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 every new set of values that are appended
below the given list in sheet 1 of the attached excel sheet.
*Sandeep Kumar Baranwal*
Credit Risk Methodology & Wholesale Basel
Gurgaon
Mob:-08588802543
On Fri, Jul 6, 2012 at 6:23 PM, Rajan_Verma <rajanverma1...@gmail.com>wrote:
> 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 verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sandeep Kumar Baranwal
> *Sent:* 05 July 2012 10:54
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ drawing chart based on the given data****
>
> ** **
>
> Hi members****
>
> ** **
>
> Would you please provide me the VBA code, such that I would be able to
> draw XY graph as per the number of data supplied?****
>
> VBA code should recognize the number of rows of data relating to the
> variables mentioned in the attached excel sheet.****
>
> ** **
>
>
> *Sandeep Kumar Baranwal*****
>
> Credit Risk Methodology & Wholesale Basel****
>
> Gurgaon****
>
> Mob:-8588802543****
>
> ** **
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------------------------------------------------------------------------------------------------------
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com****
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------------------------------------------------------------------------------------------------------
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
draw XY graph.xlsm
Description: Binary data
