|
Chart.Axes().MinimumScale Not WORKING
hi,
i have an excel application that unable to draw a chart in excel 2007, in previous version of excel, it work fine. and i found out that this error cause by x.Chart.Axes().MinimumScale=0 It failed to assigned value to MinimumScale, i has tested it, i think it only has read permission whether than re-Assign Value to this property (.MimumumScale). any idea ? DDM |
Chart.Axes().MinimumScale Not WORKING
Hi,
Are you sure that exact code worked in previous versions? This works in xl2003 and xl2007 when setting the Y axis Dim x As ChartObject Set x = ActiveSheet.ChartObjects(1) x.Chart.Axes(xlValue, xlPrimary).MinimumScale = 0 If you still have problems post back with details on the type of chart and the code for declaring and assign x Cheers Andy ddm wrote: hi, i have an excel application that unable to draw a chart in excel 2007, in previous version of excel, it work fine. and i found out that this error cause by x.Chart.Axes().MinimumScale=0 It failed to assigned value to MinimumScale, i has tested it, i think it only has read permission whether than re-Assign Value to this property (.MimumumScale). any idea ? DDM -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Chart.Axes().MinimumScale Not WORKING
Hi Andy,
The Code will like below, Private ws as WorkSheet Dim oChart as ChartObject set oChart=ws.ChartObjects("Chart_" & Format(miId,"00")) oChart.Charts.Axes(xlCategory).Minimumscale=0 the application error at above line, and i has check line above, i able to display the value inside the minimumscale but unable to assign value to it. and all this code inside an Add-in. regards DDM " "Andy Pope" wrote: Hi, Are you sure that exact code worked in previous versions? This works in xl2003 and xl2007 when setting the Y axis Dim x As ChartObject Set x = ActiveSheet.ChartObjects(1) x.Chart.Axes(xlValue, xlPrimary).MinimumScale = 0 If you still have problems post back with details on the type of chart and the code for declaring and assign x Cheers Andy ddm wrote: hi, i have an excel application that unable to draw a chart in excel 2007, in previous version of excel, it work fine. and i found out that this error cause by x.Chart.Axes().MinimumScale=0 It failed to assigned value to MinimumScale, i has tested it, i think it only has read permission whether than re-Assign Value to this property (.MimumumScale). any idea ? DDM -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Chart.Axes().MinimumScale Not WORKING
Hi,
Try this revision oChart.Chart.Axes(xlCategory).MinimumScale = 0 Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "ddm" wrote in message ... Hi Andy, The Code will like below, Private ws as WorkSheet Dim oChart as ChartObject set oChart=ws.ChartObjects("Chart_" & Format(miId,"00")) oChart.Charts.Axes(xlCategory).Minimumscale=0 the application error at above line, and i has check line above, i able to display the value inside the minimumscale but unable to assign value to it. and all this code inside an Add-in. regards DDM " "Andy Pope" wrote: Hi, Are you sure that exact code worked in previous versions? This works in xl2003 and xl2007 when setting the Y axis Dim x As ChartObject Set x = ActiveSheet.ChartObjects(1) x.Chart.Axes(xlValue, xlPrimary).MinimumScale = 0 If you still have problems post back with details on the type of chart and the code for declaring and assign x Cheers Andy ddm wrote: hi, i have an excel application that unable to draw a chart in excel 2007, in previous version of excel, it work fine. and i found out that this error cause by x.Chart.Axes().MinimumScale=0 It failed to assigned value to MinimumScale, i has tested it, i think it only has read permission whether than re-Assign Value to this property (.MimumumScale). any idea ? DDM -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Chart.Axes().MinimumScale Not WORKING
hi Andy,
It seems that still giving same error. DDM "Andy Pope" wrote: Hi, Try this revision oChart.Chart.Axes(xlCategory).MinimumScale = 0 Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "ddm" wrote in message ... Hi Andy, The Code will like below, Private ws as WorkSheet Dim oChart as ChartObject set oChart=ws.ChartObjects("Chart_" & Format(miId,"00")) oChart.Charts.Axes(xlCategory).Minimumscale=0 the application error at above line, and i has check line above, i able to display the value inside the minimumscale but unable to assign value to it. and all this code inside an Add-in. regards DDM " "Andy Pope" wrote: Hi, Are you sure that exact code worked in previous versions? This works in xl2003 and xl2007 when setting the Y axis Dim x As ChartObject Set x = ActiveSheet.ChartObjects(1) x.Chart.Axes(xlValue, xlPrimary).MinimumScale = 0 If you still have problems post back with details on the type of chart and the code for declaring and assign x Cheers Andy ddm wrote: hi, i have an excel application that unable to draw a chart in excel 2007, in previous version of excel, it work fine. and i found out that this error cause by x.Chart.Axes().MinimumScale=0 It failed to assigned value to MinimumScale, i has tested it, i think it only has read permission whether than re-Assign Value to this property (.MimumumScale). any idea ? DDM -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Chart.Axes().MinimumScale Not WORKING
Hi,
If you want to prepare a small example file and email it to me I will take a look. andy AT andypope DOT info Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "ddm" wrote in message ... hi Andy, It seems that still giving same error. DDM "Andy Pope" wrote: Hi, Try this revision oChart.Chart.Axes(xlCategory).MinimumScale = 0 Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "ddm" wrote in message ... Hi Andy, The Code will like below, Private ws as WorkSheet Dim oChart as ChartObject set oChart=ws.ChartObjects("Chart_" & Format(miId,"00")) oChart.Charts.Axes(xlCategory).Minimumscale=0 the application error at above line, and i has check line above, i able to display the value inside the minimumscale but unable to assign value to it. and all this code inside an Add-in. regards DDM " "Andy Pope" wrote: Hi, Are you sure that exact code worked in previous versions? This works in xl2003 and xl2007 when setting the Y axis Dim x As ChartObject Set x = ActiveSheet.ChartObjects(1) x.Chart.Axes(xlValue, xlPrimary).MinimumScale = 0 If you still have problems post back with details on the type of chart and the code for declaring and assign x Cheers Andy ddm wrote: hi, i have an excel application that unable to draw a chart in excel 2007, in previous version of excel, it work fine. and i found out that this error cause by x.Chart.Axes().MinimumScale=0 It failed to assigned value to MinimumScale, i has tested it, i think it only has read permission whether than re-Assign Value to this property (.MimumumScale). any idea ? DDM -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| All times are GMT +1. The time now is 12:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com