Re: $$Excel-Macros$$ Charts Title Font Size Change via VBA

2013-08-21 Thread Prafull Jadhav
Dear Sir, I have querys 1) I have not used Dim Declaration and run below vba it working fine.. is there need to use Dim here? Dim x As ChartObject For Each x In ActiveSheet.ChartObjects x.Activate x.Chart.ChartTitle.Select Selection.Format.TextFrame2.TextRange.Font.Name = "Arial"

Re: $$Excel-Macros$$ Charts Title Font Size Change via VBA

2013-08-21 Thread Prafull Jadhav
Thanks a lot Sir...It working Fine On Wed, Aug 21, 2013 at 1:12 PM, xlstime wrote: > Try This > > Sub Chart_Titles() > > Dim ch As ChartObject > > For Each ch In ActiveSheet.ChartObjects > > ch.Activate > ch.Chart.ChartTitle.Select > Selection.Format.TextFrame2.TextRange.Font.

Re: $$Excel-Macros$$ Charts Title Font Size Change via VBA

2013-08-21 Thread xlstime
Try This Sub Chart_Titles() Dim ch As ChartObject For Each ch In ActiveSheet.ChartObjects ch.Activate ch.Chart.ChartTitle.Select Selection.Format.TextFrame2.TextRange.Font.Name = "Arial" Selection.Format.TextFrame2.TextRange.Font.Size = 14 Next End Sub

Re: $$Excel-Macros$$ Charts

2013-06-25 Thread P.VIJAYKUMAR
Hi, the legend font, axis font, titles font, etc. are linked to the body font of the active theme (see Page Layouttab). Create a workbook template with your on theme with the desired font as the body font and save it as Book.xltxin the XLStart folder. Regards,VIJAYKUMAR On Wed, Jun 26, 2013 at

Re: $$Excel-Macros$$ Charts

2012-05-06 Thread dguillett1
Provide a file Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: joseph.cam...@gmail.com Sent: Saturday, May 05, 2012 2:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Charts Sent on my BlackBerryŽ from Vodafone -

Re: $$Excel-Macros$$ Charts in Excel

2012-03-05 Thread Shrinivas Shevde
Dear Experts I want a help for charts. I wants to make a 3 charts in one graph,but problem is that the ranges are different for eg ranges are as follows range -1 =: 13 to 15 range -2 =: 19 to 22 range -1 =: 28 to 32 If i make all the charts in one graph then the scale will taken as from (min

Re: $$Excel-Macros$$ Charts in Excel

2012-02-28 Thread PrIyAnKa
THanks Abhishek ,its also done On Wed, Feb 29, 2012 at 12:53 PM, Abhishek Jain wrote: > http://peltiertech.com/Excel/Charts/ComboCharts.html > > > On Wed, Feb 29, 2012 at 11:45 AM, PrIyAnKa wrote: > >> have already downloaded all and have learnt some charts from chandoo org. >> >> Thanka >> >>

Re: $$Excel-Macros$$ Charts in Excel

2012-02-28 Thread Abhishek Jain
http://peltiertech.com/Excel/Charts/ComboCharts.html On Wed, Feb 29, 2012 at 11:45 AM, PrIyAnKa wrote: > have already downloaded all and have learnt some charts from chandoo org. > > Thanka > > On Wed, Feb 29, 2012 at 11:15 AM, NOORAIN ANSARI > wrote: > >> Hi Priyanka, >> >> Please visit on C

Re: $$Excel-Macros$$ Charts in Excel

2012-02-28 Thread PrIyAnKa
have already downloaded all and have learnt some charts from chandoo org. Thanka On Wed, Feb 29, 2012 at 11:15 AM, NOORAIN ANSARI wrote: > Hi Priyanka, > > Please visit on Chandoo site, he has good colletions of charts > > see below link.. > http://chandoo.org/wp/2009/11/30/quick-chart-formatti

Re: $$Excel-Macros$$ Charts in Excel

2012-02-28 Thread NOORAIN ANSARI
Hi Priyanka, Please visit on Chandoo site, he has good colletions of charts see below link.. http://chandoo.org/wp/2009/11/30/quick-chart-formatting/ On Wed, Feb 29, 2012 at 10:51 AM, PrIyAnKa wrote: > Dear Team > > Kindly provide link or excel help files to create different charts, > > This i