Chart X Axis Scaling

**proton** · 09-28-2006, 04:56 AM

Hello,
Please help me with macro which can shift (increase by 7)
X axis scale maximum and minimum values.
Thanks a lot!

**Bryan Hessey** · 09-28-2006, 05:32 AM

Originally Posted by proton

Hello,
Please help me with macro which can shift (increase by 7)
X axis scale maximum and minimum values.
Thanks a lot!

Did you know what they wee before?

Please Login or Register  to view this content.

amends the x axis (for series 1), and

Please Login or Register  to view this content.

adjusts the Y axis limits.

does this help?
---

**proton** · 09-28-2006, 08:38 AM

.MinimumScale = 6
.MaximumScale = 9
must be variables and avery time must increase by 7

**Bryan Hessey** · 09-28-2006, 12:36 PM

Originally Posted by proton

.MinimumScale = 6
.MaximumScale = 9
must be variables and avery time must increase by 7

Please Login or Register  to view this content.

which could then be stored, probably as a cell value in a cell of your choice.

---