Setting the minimum/maximum display range of a chart
Hi,
You need to use code, here is a sample you will need to modify for you
situation:
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.Axes(xlValue).Select
With ActiveChart.Axes(xlValue)
.MinimumScale = Date - 30
.MaximumScale = Date + 30
End With
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Babymech" wrote:
I thought I posted this question yesterday, but can't find it today so I'll
repost and hope for the best.
Basically I'm using a stacked bar chart as a GANTT schedule, and want to
ensure that the minimum and maximum display ranges are set to something
relevant... What I want to do then is, ideally, to enter =TODAY()-30 (for
example) as the minimum range and =TODAY()+30 as the maximum, but obviously
this doesn't work in a straightforward way... does anybody know of a
workaround for this, so that I can set the minimum range as an equation, or a
reference?
All suggestions are appreciated - thanks!
|