Dear Guillett Sir
I am confused about this code,I put this code but what changes in sheet,I
am not under stand.Pls in attached sheet solved problem if possible.I think
in to cell from date & Last date input through data validation & when I
change range date then update chart between that date range.
Thanks for reply
Amar
On Mon, Aug 13, 2012 at 7:08 PM, dguillett1 <dguille...@gmail.com> wrote:
> Sub namechart()
> For Each c In ActiveSheet.ChartObjects
> c.Name = InputBox("Change the chart name " & c.Name)
> Next c
> End Sub
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *From:* amar takale <amartak...@gmail.com>
> *Sent:* Monday, August 13, 2012 1:58 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Chart Update Within Date Data Range
>
> I will Attached file Pls solved me problem
>
> On Fri, Aug 10, 2012 at 3:35 PM, NOORAIN ANSARI
> <noorain.ans...@gmail.com>wrote:
>
>> after typing = in Formula bar, Please select I2 cell then press Enter
>>
>>
>> On Fri, Aug 10, 2012 at 3:33 PM, Imran khan <ikha...@gmail.com> wrote:
>>
>>> Hi Noorain,
>>>
>>> I am not able do it. When i am selecting Chart title, when typing =, it
>>> remains = only
>>>
>>>
>>> On Fri, Aug 10, 2012 at 3:15 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
>>>> Hi Imran,
>>>>
>>>> First you select Chart Title then goto Formula Bar, Type = and select
>>>> Cell "I2"
>>>>
>>>> Hope it will help to you.
>>>>
>>>> On Fri, Aug 10, 2012 at 3:11 PM, Imran khan <ikha...@gmail.com> wrote:
>>>>
>>>>> Hi Noorain,
>>>>>
>>>>> How we write formula in Text Box, as you write " Jan to May"
>>>>> (='Dynamic Char 2'$I$2). Could you please guide us. Can we do simply put =
>>>>> and then go to cell?
>>>>>
>>>>> Regards,
>>>>> Imran
>>>>>
>>>>>
>>>>> On Fri, Aug 10, 2012 at 3:02 PM, NOORAIN ANSARI <
>>>>> noorain.ans...@gmail.com> wrote:
>>>>>
>>>>>> Dear Amar,
>>>>>>
>>>>>> Please find attached Sample file, hope it will fulfill you
>>>>>> expectation.
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> With Regards,
>>>>>> Noorain Ansari
>>>>>> http://
>>>>>> <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com>
>>>>>> http://
>>>>>> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com>
>>>>>>
>>>>>>
>>>>>> On Fri, Aug 10, 2012 at 2:19 PM, amar takale <amartak...@gmail.com>wrote:
>>>>>>
>>>>>>> Dear sir,
>>>>>>> I have One Chart File with Data,I want to if I changed Date from...
>>>>>>> to..... (In particular two cell start & End date) Then automatically
>>>>>>> changed chart Range & Update Chart that within Date range.
>>>>>>> Pls send me Example file Then I will use that in my excel
>>>>>>>
>>>>>>> Thank Sir
>>>>>>> Amar --
>>>>>>> Join official facebook page of this forum @
>>>>>>> https://www.facebook.com/discussexcel
>>>>>>>
>>>>>>> FORUM RULES (1120+ 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.
>>>>>>>
>>>>>>> 6) Jobs posting is not allowed.
>>>>>>>
>>>>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>>>>>>> allowed.
>>>>>>>
>>>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>>>> Forum owners and members are not responsible for any loss.
>>>>>>> ---
>>>>>>> You received this message because you are subscribed to the Google
>>>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>>>>> To unsubscribe from this group, send email to
>>>>>>> mailto:excel-macros%2bunsubscr...@googlegroups.com<excel-macros%2bunsubscr...@googlegroups.com>
>>>>>>> .
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Join official facebook page of this forum @
>>>>>> https://www.facebook.com/discussexcel
>>>>>>
>>>>>> FORUM RULES (1120+ 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.
>>>>>>
>>>>>> 6) Jobs posting is not allowed.
>>>>>>
>>>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>>>>>> allowed.
>>>>>>
>>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>>> Forum owners and members are not responsible for any loss.
>>>>>> ---
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>>>> To unsubscribe from this group, send email to
>>>>>> mailto:excel-macros%2bunsubscr...@googlegroups.com<excel-macros%2bunsubscr...@googlegroups.com>
>>>>>> .
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Join official facebook page of this forum @
>>>>> https://www.facebook.com/discussexcel
>>>>>
>>>>> FORUM RULES (1120+ 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.
>>>>>
>>>>> 6) Jobs posting is not allowed.
>>>>>
>>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>>>>> allowed.
>>>>>
>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>> Forum owners and members are not responsible for any loss.
>>>>> ---
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>>> To unsubscribe from this group, send email to
>>>>> mailto:excel-macros%2bunsubscr...@googlegroups.com<excel-macros%2bunsubscr...@googlegroups.com>
>>>>> .
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> With Regards,
>>>> Noorain Ansari
>>>> http://
>>>> <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com>
>>>> http://
>>>> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com>
>>>>
>>>>
>>>> --
>>>> Join official facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES (1120+ 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.
>>>>
>>>> 6) Jobs posting is not allowed.
>>>>
>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> To unsubscribe from this group, send email to
>>>> mailto:excel-macros%2bunsubscr...@googlegroups.com<excel-macros%2bunsubscr...@googlegroups.com>
>>>> .
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> mailto:excel-macros%2bunsubscr...@googlegroups.com<excel-macros%2bunsubscr...@googlegroups.com>
>>> .
>>>
>>>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http://
>> <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com>
>> http://
>> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com>
>>
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> mailto:excel-macros%2bunsubscr...@googlegroups.com<excel-macros%2bunsubscr...@googlegroups.com>
>> .
>>
>>
>>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ 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.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
