Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formating x and 7 axis
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 |
#2
|
|||
|
|||
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/...nkToSheet.html Cheers Andy Tony wrote: 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, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
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/ _______ Andy Pope wrote: 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/...nkToSheet.html Cheers Andy Tony wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |