Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 7th 10, 07:45 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 1
Default 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   Report Post  
Old January 7th 10, 08:50 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change where category x axis crosses the 2nd y axis? epu Charts and Charting in Excel 7 October 28th 08 02:31 PM
Using a cell reference as the axis value for Horizontal axis crosses [email protected] Charts and Charting in Excel 4 January 25th 08 01:59 PM
make chart with both horizontal-x axis vertical-y axis CEmery Charts and Charting in Excel 1 December 19th 07 07:11 PM
Value (Y) axis crosses between categories and Secondary Value (Y) Axis -markc Charts and Charting in Excel 2 October 31st 07 07:03 PM
Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit Pedant Charts and Charting in Excel 1 August 29th 05 03:50 AM


All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017