Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Having two X-axes on same chart | Excel Discussion (Misc queries) | |||
xy chart -- x and y axes scales min and max | Charts and Charting in Excel | |||
XY-Chart with 4 axes | Charts and Charting in Excel | |||
Excel macro stops at MinimumScaleISAuto and MinimumScale = 0 | Charts and Charting in Excel | |||
Scaled Chart Axes | Charts and Charting in Excel |