Customize axis scale

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Felipe - 22 Aug 2003 20:14 GMT

I have a spreadsheet with dates and data to be graphed for
each date. I would like to customize the x-axis(time)
scale without having to edit the chart. The graph will be
used and seen by many users, so I would like the user to
input the initial and final dates in cells so the scale is
automaticaly updated.

I tried writing a macro for this and asigning it to a
botton, but I get an error in the following line:
.MinimumScale = Range("E2").Value

E2 is the celll where the user inputs initial date.

I would apreciate help with the VBA code, and would like
to know if you can think of a simpler way to do this.

Thanks for your help,
Felipe

Reply to this Message

Debra Dalgleish - 22 Aug 2003 22:07 GMT

The following code, run from a command button, worked:

Sub ChangeScale()
ActiveSheet.ChartObjects(1).Activate
With ActiveChart.Axes(xlCategory)
.MinimumScale = Range("E2").Value
End With
End Sub

Are you sure that the value in cell E2 is a valid date?
What error are you getting?

> I have a spreadsheet with dates and data to be graphed for
> each date. I would like to customize the x-axis(time)
[quoted text clipped - 14 lines]
> Thanks for your help,
> Felipe

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

Felipe I - 25 Aug 2003 21:53 GMT

It worked!

Thank you very much ... I still don´t know what I was
doing wrong though...

>-----Original Message-----
>The following code, run from a command button, worked:
[quoted text clipped - 27 lines]
>> Thanks for your help,
>> Felipe

Reply to this Message