Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming for Excel Charts
The code below gives a Type Mismatch error on the .MinimumScale = startmonth
and the line afterward. This worked in Excel 2003 but gives the error in Excel 2007. It appears you cannot use a string with the MinimumScale command. Any ideas how to work around this? startmonth and stopmonth are dates such as 01/01 and 01/31. Below is the VBA code. Chart1.Activate ActiveChart.Axes(xlCategory).Select With ActiveChart.Axes(xlCategory) .MinimumScaleIsAuto = False .MaximumScaleIsAuto = False .MinimumScale = startmonth .MaximumScale = endmonth |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
Need help programming charts | Excel Programming | |||
Programming Charts | Charts and Charting in Excel | |||
Programming pasting charts to work problem | Excel Programming | |||
Programming Organisation Charts | Excel Programming |