http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html http://msdn.microsoft.com/en-us/library/hh243933.aspx http://support.microsoft.com/kb/146055
On Fri, Jul 6, 2012 at 11:03 PM, Sandeep Kumar Baranwal <
sandeepkumarbaran...@gmail.com> wrote:
> Hi Sir
>
> Thanks for introducing me the use of dynamic range assignment.
> thanks a lot for you help.
> can there be VBA code as an alternative to using dynamic range for drawing
> the chart? If yes, will you please introduce me to that as well?
>
> *Sandeep Kumar Baranwal*
> Credit Risk Methodology & Wholesale Basel
> Gurgaon
> Mob:-08588802543
>
>
>
>
> On Fri, Jul 6, 2012 at 10:55 PM, Rajan_Verma <rajanverma1...@gmail.com>wrote:
>
>> ** **
>>
>> Hi Sandeep ,****
>>
>> Is that what you wanted. ?****
>>
>> ** **
>>
>> Actually I have used Dynamic Ranges in the charts . so no vba code needed
>> to update the chart at the time of adding data,****
>>
>> ** **
>>
>> You can see the name ranges by pressing Ctrl+F3****
>>
>> ** **
>>
>> ** **
>>
>> * *
>>
>> *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 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 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****
>>
>> --
>> 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<<image001.png>>
