|
Default values
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 |
Default values
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 |
Default values
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 |
Default values
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 |
| All times are GMT +1. The time now is 03:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com