| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
XY Chart - Vertical Axis Crosses - Cell reference vs. Value
I would like to have the Axis Value refer to the result of a formula. My XY
chart is a 4 quadrant view of data points. I want the vertical axis to cross at the median value for the range. I can enter the number by hand but I can't use the cell reference. Thanks, Joe |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
XY Chart - Vertical Axis Crosses - Cell reference vs. Value
Hi,
You will have to solve this with some VBA code. This example is for Scales min/max value but the principle is the same. http://peltiertech.com/Excel/Charts/...nkToSheet.html This is the code for setting the corresat value. With ActiveChart.Axes(xlCategory) .Crosses = xlCustom .CrossesAt = 2.5 End With Cheers Andy Joe Dunbar wrote: I would like to have the Axis Value refer to the result of a formula. My XY chart is a 4 quadrant view of data points. I want the vertical axis to cross at the median value for the range. I can enter the number by hand but I can't use the cell reference. Thanks, Joe -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change where category x axis crosses the 2nd y axis? | Charts and Charting in Excel | |||
| Using a cell reference as the axis value for Horizontal axis crosses | Charts and Charting in Excel | |||
| make chart with both horizontal-x axis vertical-y axis | Charts and Charting in Excel | |||
| Value (Y) axis crosses between categories and Secondary Value (Y) Axis | Charts and Charting in Excel | |||
| Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit | Charts and Charting in Excel | |||
Linear Mode
