Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with forcing chart axes scale
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with forcing chart axes scale
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" wrote in message ... 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scale on Axes | Charts and Charting in Excel | |||
Code about setting Y Axes scale. | Charts and Charting in Excel | |||
2 Axes, same scale wanted | Charts and Charting in Excel | |||
How do I scale excel chart axes from vb? | Charts and Charting in Excel | |||
Change Axes Scale Dynamically | Charts and Charting in Excel |