If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#9
|
|||
|
|||
Focus / Targeting Lines on a Chart
Hi Jon,
Yes the error bars solution is the easiest quick fix. For the example set the Fixed values to 120 for the X bars and 100 for the Y bars. Jon Peltier wrote: Andy - Without checking out your example, can I suggest error bars that span the chart? These can be linked to cells that calculate the required length based on the point of intersection. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Andy Pope wrote: Hi Max, Tackle b first, its easiest. The workbook already contains a chartsheet and a chartobject example. You could try increasing the size of the datapoint marker, although I suspect even when increased to the maximum size (72) it will not reach the edges. Therefore you need to replace the single data marker with two lines, which will require additional data. Use the same principle to control the x,y positions. If you have problems adapting your chart then you can email me and I will have a look see. Max wrote: Andy, many thanks. Yes, it's pretty close to what I'm after... just 2 wishes: a. Could the cross-hairs be "expanded" to stretch right across / down ? This is to enable easy read-off of values in the x & y axis for points of interests in the chart. b. Could the chart be located in a chartsheet *and* the cross-hair controls placed there to work ? This would enable a bigger entire screen display to facilitate chart visibility by parties discussing. -- Rgds Max xl 97 ---------------------------------------------------- Use xdemechanik atyahoodotcom for email ----------------------------------------------------- "Andy Pope" wrote in message ... Hi Max, Check out this example I have created. (http://www.andypope.info/ngs/ng26.htm) It uses a extra data series to create the cross hairs. The scrollers allow dynamic movement of them. Max wrote: Ok, I've gone through the 2 links but was unable to find what was desired. Perhaps a re-clarification. What I'm looking for is a sort of "overlay" movable cross-hair grid ("superimposed") for use in a chartsheet (not something to be plotted in the chart itself) The cross-hair grid could be manipulated to say, highlight points of intersection of lines / curves in the course of a briefing on the chartsheet. -- Rgds Max xl 97 ---------------------------------------------------- Use xdemechanik atyahoodotcom for email ----------------------------------------------------- -- Cheers Andy ------ Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Cheers Andy ------ Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|