Programaticaly Change Chart Properties (1 Viewer)

[MikeSr]

I have a chart with the Y axis showing temperature, and the X axis showing time.
With the Chart in the Design mode and then double clicking to get to the graph properties, I select the X axis, right click "Format Axis". Under the Scale Tab there are 3 numberical entries:
"Value(Y) Axis Crosses at category Number : my value = "1"
"Number of categories between tick-mark labels" my value = "60"
"Number of categories between tick-marks: my value = "1"

Check boxe's below used are "Value (Y) axis crosses between categories

My problem is that depending on how many days worth of data I show, the X axis times become unreadable. So I would like to know how to change these properties programaticaly.

Just can't seem to find the correct class and methods to do it.
Any help would be very much appreciated.

Michael

 

[darbid]

The way I would solve your problem is to set up a similar chart in Excel. Then record a macro while changing these properties.

This is going to give you a pretty good idea if not the exact method as the excel chart is very similar to the graph object model.