formating x and 7 axis

[Tony]

I am creating a scatter plot and would like the x & y axis to cross at a
certain intersection. An example would be I have several different porducts
that are sold at different price points. I would like the x & y axis to
cross at our staple products price (x axis) point and quantity (y axis).

Is there a way for me to point the graph to look at a certain cells for the
intersection point?

Thanks

 

[Andy Pope]

Hi,

You can not directly like the axis properties to a cell.
You can do it with a VBA routine. You can even get it to run
automatically by using the Worksheet_Change(ByVal Target As Range) event.

Have a look at Jon Peltier's explanation, which you can expand upon to
include the Crosses properties.
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

Cheers
Andy

 

[Jon Peltier]

If you know what the values are, you can manually set the crossing points of the
axes. Double click the X axis, and on the Scale tab, enter the value you want in the
box for Y (Value) Axis Crosses At. Repeat for the Y axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______