Visual Basic, Excel/VBA graphics: Settings X-axis scale properties in VBA

Excel/VBA graphics: Settings X-axis scale properties in VBA

Author	Message
Dana Murr #1 / 2	Excel/VBA graphics: Settings X-axis scale properties in VBA The X-axis ScaleType property of an existing chart can be set by hand to xlLogarithmic. The Excel 5 Visual Basic for Applications Reference Manual and the help File say one cannot. Likewise, the MaximumScale and the MinimumScale properties can also be changed by hand, although one is not supposed to be able to do so. These steps can be recorded in a macro, but when I execute the macro, it runs into a problem. :-( What control does one have, through Visual Basic, on the X-axis scale properties ? Suggestions will be greatly appreciated. Thank you Daniel M Murray
Wed, 12 Nov 1997 03:00:00 GMT

bdetr.. #2 / 2	Excel/VBA graphics: Settings X-axis scale properties in VBA Quote: > The X-axis ScaleType property of an existing chart can be set by hand to > xlLogarithmic. The Excel 5 Visual Basic for Applications Reference Manual and > the help File say one cannot. Likewise, the MaximumScale and the > MinimumScale properties can also be changed by hand, although one is not > supposed to be able to do so. These steps can be recorded in a macro, but > when I execute the macro, it runs into a problem. :-( I also thought it was wierd to record a macro changing the X-axis limits and watch if fail. Microsoft sent me a 5.0c upgrade which fixed the problem. It sounds like you are using 5.0 or 5.0a. I don't know if you can get a free upgrade or not but good luck. The upgrade also fixes a few other charting bugs that I found such as line and marker backgound colors being set wrong by a macro. Bret
Sun, 16 Nov 1997 03:00:00 GMT

Page 1 of 1

[ 2 post ]