Prev: Blinking Text
Next: Save in different folder
From: Glenn Kammerer on 22 May 2010 12:58
Windows XP Pro SP3
Excel 2007

I wrote a pretty simple interface to help my daughter with graphing
algebra functions. The form allows her to specify the number of data
points, a range of X values and coefficient values for polynomials,
and then I simply write the coordinates to a sheet and the pre-made
chart automatically graphs the function. What I can't figure out is
how to force the X and Y axes to be the same scale. I'd also like to
be able make both axes intersect at other's zeros like in a Cartesian
System. I can determine if the origin should be "visible" based on
the range of values specified in the form, but I can't seem to make
the Y axis be anywhere but the sides of the graph.

Oh, in case I wasn't clear enough, I'm looking to do this in VBA. Any
and all help appreciated, thanks!!
From: JLGWhiz on 22 May 2010 13:56

You can right click the scale caption for the Y axis and it will bring up a
menu for options. One of the options is the scale settings. Same thing
with the X axis. Excel then uses your numbers to recalc the chart
parameters. Be careful, some odd results occur.



"Glenn Kammerer" <sandusky40(a)gmail.com> wrote in message
news:7ff83a2a-9496-410a-bf09-4291626d1a1b(a)l6g2000vbo.googlegroups.com...
> Windows XP Pro SP3
> Excel 2007
>
> I wrote a pretty simple interface to help my daughter with graphing
> algebra functions. The form allows her to specify the number of data
> points, a range of X values and coefficient values for polynomials,
> and then I simply write the coordinates to a sheet and the pre-made
> chart automatically graphs the function. What I can't figure out is
> how to force the X and Y axes to be the same scale. I'd also like to
> be able make both axes intersect at other's zeros like in a Cartesian
> System. I can determine if the origin should be "visible" based on
> the range of values specified in the form, but I can't seem to make
> the Y axis be anywhere but the sides of the graph.
>
> Oh, in case I wasn't clear enough, I'm looking to do this in VBA. Any
> and all help appreciated, thanks!!


 | 
Pages: 1
Prev: Blinking Text
Next: Save in different folder