setting ActiveChart.Axes(xlCategory).MinimumScale not working

T

Teddy

Hi

Following code does not have any effect.
What di I miss??

Excel 2007
XY plot
X axis is date and hour

min_date = Sheet2.Range("start_tid").Value
Sheet2.ChartObjects("Diagram 4").Activate
ActiveChart.Axes(xlCategory).MinimumScale = min_date

Thanks cheers
 
B

Barb Reinhardt

I'd suggest looking at what you have for Min and Max axis scales before you
make a change. Is it possible that your min value is > than your Max value?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Axes(xlCategory) for a chart-sheet in 2007 2
Excel 2003 to 2007 VBA Change 0
Excel 2007 Rect type problem 1
MinimumScale method of Axis Object failed 1
reverse axis not working as before... 0
dynamic chart range with VBA 6
Chart Type - numeric values 3
Date values not appearing correclty in the x-axis 1

Top