Link to home
Start Free TrialLog in
Avatar of Moiz Saifuddin
Moiz Saifuddin

asked on

vba min,max

Im getting an error in setting the min and max for the Y-axis for a vba excel chart and am attaching a screenshot for showing the error im receiving while running this macro..

With ActiveChart.ChartObjects("Chart5").Axes(xlCategory)
                        .MinimumScale = 20
                        .MaximumScale = 90
                    End With
                    

Open in new window


Basically this code was implemented throught this link

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html
error.jpg
Avatar of Chris Raisin
Chris Raisin
Flag of Australia image

When you click "Debug" which line is highlighted in your code?

Cheers
Chris
ASKER CERTIFIED SOLUTION
Avatar of Moiz Saifuddin
Moiz Saifuddin

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Moiz Saifuddin
Moiz Saifuddin

ASKER

solution found for this