Hello!
I'm (still) making my dynamic charts from access to excel. Everything's
working just fine, except the fact that all properties (like gridelines,
legend position, axis names...) are set to default values, and I want to
modify them. Does anyone know how and why are they set to default properties?
Thanks, you've been most helpfull so far!
Ana

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200906/1

Basically the steps a select a chart that with the formatting required;
right-click the chart and choose Chart Type; check the "Default" box in the
dialog. From then on all new charts 'inherit' the formatting of the chosen
chart

This has screen shots for Excel 2003
http://www.officearticles.com/excel/...soft_excel.htm

This has screen captures for doing it in Excel 2007
http://www.nirmaltv.com/2008/11/25/h...in-excel-2007/

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Ana via OfficeKB.com" <u51486@uwe wrote in message
news:98208f362545d@uwe...
Hello!
I'm (still) making my dynamic charts from access to excel. Everything's
working just fine, except the fact that all properties (like gridelines,
legend position, axis names...) are set to default values, and I want to
modify them. Does anyone know how and why are they set to default
properties?
Thanks, you've been most helpfull so far!
Ana

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200906/1

Thx,but that's not actually what I needed.I need VBA code to put into my
access code so that when I send table from access to excel, I can change it,
and put white plot area and bold font etc. I have a code for that but it is
just NOT working and I don't know why. Everything I say like for example
xpAcc.ActiveChart.Legend. Position = xlBottom he just ignore and sets
everything on default (legend position left).
Any ideas?
Ana

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200906/1

I suggest you post your question to the excel.programming newsgroup and show
you code in the message
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Ana via OfficeKB.com" <u51486@uwe wrote in message
news:982b0d5a289f9@uwe...
Thx,but that's not actually what I needed.I need VBA code to put into my
access code so that when I send table from access to excel, I can change
it,
and put white plot area and bold font etc. I have a code for that but it
is
just NOT working and I don't know why. Everything I say like for example
xpAcc.ActiveChart.Legend. Position = xlBottom he just ignore and sets
everything on default (legend position left).
Any ideas?
Ana

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200906/1