Hi!
I have a problem with a copying macro that moves charts from excel to
powerpoint. It is based on one of the many existing macros out there - i
just changed a couple of settings and instead of placing metapictures, it
now uses the command bar paste button to keep the charts in powerpoint
ed
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"
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.
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
Dear All,
Very Good Morning,
I have made 10 charts and now I want to change the Size of Font 14 to 9
for Chart Title.
is it possible to change it through the VBA
for example
For each
For Next
Do until
if yes , Please provide the same
Thanks in Advance
Regards,
Prafull Jadhav.
--
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
Hi,
Is there a way to make default font for charts we prepare in excel every time.
At present it is Calibri, I want to change it Century Gothic style for all the
new charts I create.
Regards,
Krishnaraddi V Madolli.
"CONFIDENTIALITY NOTICE: This message and any attachment are confidential and
Hi Experts,
I have been trying to plot a chart for the attached datas. i have
tried so many charts, like bar, line pie etc and etc, i am unable to plot
the chart in meaningful way.
Can somebody please suggest me to plot the chart such that everyone can
easily understand in one attempt.
Ex
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
Sent on my BlackBerry® from Vodafone
-Original Message-
From: joseph.cam...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 5 May 2012 04:32:26
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Charts
Hi,
I create a lot of stacked charts and I spend a
Hi,
I create a lot of stacked charts and I spend a lot of time formatting the
overlapped numbers.
I need a macro that will move numbers that overlap other numbers in a stacked
chart.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (986+ members already BANNED for violation
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
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
>>
>>
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
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
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
Dear Team
Kindly provide link or excel help files to create different charts,
This is just for learning purpose so not sharing any excel file
Regards
Priyanka
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Hel
Hi Group,
i want to plot a chart "Line-column on 2-Axis".
There is a option to plot this chart in custom charts in excel 2003.
But i am not able to find it in excel 2007.
there is also "chart options" in excel2003 where we can modify the chart and
give names/ labels, but there is no as such o
Hi all.
I have a X-coordinate and some Y-coordinate and want to make a chart
(with macro).
X
-5
-4
-3
-2
-1
0
1
2
3
4
5
Y2
-5,307692308
-4,076923077
-2,846153846
-1,615384615
-0,384615385
0,846153846
2,076923077
3,307692308
4,538461538
5,769230769
7
Y1
-4,2
-2,6
-1
0,6
2,2
3,8
5,4
7
8,6
10,2
19 matches
Mail list logo
