Hi Ranjan Sir Thanks. That was really very innovative. The solution that you provide takes one year after the another. But my requirement is to take the complete set of values relating to different years , given at a time, in one go and plot chart accordingly.The chart must depict all the years and related age & salary in one chart itself Precisely,I would like you to use a command button and work on the table relating to year, age and salary.My requirement is to draw two graphs in one chart itself ,* using VBA code:* 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 Sat, Jul 7, 2012 at 12:25 PM, Deba Ranjan <drdeva...@gmail.com> wrote:
> Dear Sandeep,
>
> PFA the Chart. Hope this will give you better result as per your
> requirements. And you can change the graph as per desire. Just click the
> date and and you will find the graph changing.
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
> ****
>
>
> On Fri, Jul 6, 2012 at 11:07 PM, Sandeep Kumar Baranwal <
> sandeepkumarbaran...@gmail.com> wrote:
>
>> Hi Ashish SIr
>>
>> My requirement is to draw two graphs in one chart itself , using VBA code:
>> 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 10:29 PM, ashish koul <koul.ash...@gmail.com>wrote:
>>
>>> which chart you want to create can you share the chart.. so that we can
>>> write the vba code for the same ..
>>>
>>>
>>> Regards
>>> Ashish
>>>
>>>
>>> On Fri, Jul 6, 2012 at 10:21 PM, Sandeep Kumar Baranwal <
>>> sandeepkumarbaran...@gmail.com> wrote:
>>>
>>>> Respected Rajan Sir
>>>>
>>>> I am not able to locate the related VBA code in the attached excel
>>>> sheet.
>>>> Will you please provide the VBA code.
>>>>
>>>> *Sandeep Kumar Baranwal*
>>>> Credit Risk Methodology & Wholesale Basel
>>>> Gurgaon
>>>> Mob:-08588802543
>>>>
>>>>
>>>>
>>>>
>>>> On Fri, Jul 6, 2012 at 9:02 PM, Rajan_Verma
>>>> <rajanverma1...@gmail.com>wrote:
>>>>
>>>>> ** **
>>>>>
>>>>> ** **
>>>>>
>>>>> 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****
>>>>>
>>>>> ** **
>>>>>
>>>>> --
>>>>> 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
>>>>
>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *http://www.excelvbamacros.com/*
>>> *http://www.accessvbamacros.com/* <http://www.accessvbamacros.com/>
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>> --
>>> 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
>
--
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>>
