rt.SetSourceData rngSource
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of hilary lomotey
Sent: Apr/Fri/2012 03:39
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Truncate years if data not available in Chart
Rajan pls what di
; excel-macros@googlegroups.com] *On Behalf Of *Divaker Pandey
> *Sent:* Apr/Thu/2012 10:02
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Truncate years if data not available in
> Chart
>
> ** **
>
> Thanks Rajan, it is good, but not solve my pr
Hi
Please see the revised version
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Divaker Pandey
Sent: Apr/Thu/2012 10:02
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Truncate years if data not available in Chart
Thanks
don’t have data.
>
> Rajan
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Divaker Pandey
> *Sent:* Apr/Thu/2012 08:17
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$
Please find attached sheet
I am just hiding Column if don't have data.
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Divaker Pandey
Sent: Apr/Thu/2012 08:17
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Truncate years if
Hi Dear,
Please See attached book,
I want to make chart for a period range, but if data not available for
starting period, it must be truncate.
is there any solution without VBA.
Thanks & Regards,
Divaker
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate t
