Do you want this ? See the attached sheet.. you can append table Regards 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 8:51 To: excel-macros@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-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 <mailto:excel-macros%2bunsubscr...@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
<<image001.png>>
Copy of draw XY graph.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
