Focus / Targeting Lines on a Chart

Hi guys,

Let's say I have a chart in a chartsheet.

I'll like a visual aid to be able to direct, say, a discussion's focus
from one point on the chart to another.

Is there a way to put something like a "movable"
vertical / horizontal targeting lines [a cross-hair?] to accomplish this?
(something similar to Chip Pearson's Rowliner in a sheet?)

Grateful for any insights.

Thanks in advance.
--
Rgds
Max
xl 97
----------------------------------
Use xdemechanik <at>yahoo<dot>com for email
-----------------------------------------

Hi Max,

Have a look at these examples of adding reference lines to charts,

Jon Peltier's page,
(http://peltiertech.com/Excel/Charts...es.html#AddLine)

or mine,
(http://www.andypope.info/charts/averageline.htm)

Max wrote:
> Hi guys,
>
> Let's say I have a chart in a chartsheet.
>
> I'll like a visual aid to be able to direct, say, a discussion's focus
> from one point on the chart to another.
>
> Is there a way to put something like a "movable"
> vertical / horizontal targeting lines [a cross-hair?] to accomplish this?
> (something similar to Chip Pearson's Rowliner in a sheet?)
>
> Grateful for any insights.
>
> Thanks in advance.
> --
> Rgds
> Max
> xl 97
> ----------------------------------
> Use xdemechanik <at>yahoo<dot>com for email
> -----------------------------------------
>
>

--
Cheers
Andy

------
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks for the links, Andy!

I'll dig through and feedback further here.

--
Rgds
Max
xl 97
----------------------------------
Use xdemechanik <at>yahoo<dot>com for email
-----------------------------------------
"Andy Pope" <andy@andypope.info> wrote in message
news:#SOYm4u7DHA.3288@TK2MSFTNGP11.phx.gbl...
> Hi Max,
>
> Have a look at these examples of adding reference lines to charts,
>
> Jon Peltier's page,
> (http://peltiertech.com/Excel/Charts...es.html#AddLine)
>
> or mine,
> (http://www.andypope.info/charts/averageline.htm)
> --
> Cheers
> Andy
>
> ------
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info

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 <at>yahoo<dot>com for email
-----------------------------------------------------

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 <at>yahoo<dot>com for email
> -----------------------------------------------------
>
>

--
Cheers
Andy

------
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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 <at>yahoo<dot>com for email
-----------------------------------------------------
"Andy Pope" <andy@andypope.info> wrote in message
news:OIzMikx7DHA.696@tk2msftngp13.phx.gbl...
> 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 <at>yahoo<dot>com for email
> > -----------------------------------------------------
> >
> >
>
> --
> Cheers
> Andy
>
> ------
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>

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 <at>yahoo<dot>com for email
> -----------------------------------------------------
> "Andy Pope" <andy@andypope.info> wrote in message
> news:OIzMikx7DHA.696@tk2msftngp13.phx.gbl...
>
>>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 <at>yahoo<dot>com for email
>>>-----------------------------------------------------
>>>
>>>
>>
>>--
>>Cheers
>>Andy
>>
>>------
>>Andy Pope, Microsoft MVP - Excel
>>http://www.andypope.info
>>
>
>
>

--
Cheers
Andy

------
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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 <at>yahoo<dot>com for email
>> -----------------------------------------------------
>> "Andy Pope" <andy@andypope.info> wrote in message
>> news:OIzMikx7DHA.696@tk2msftngp13.phx.gbl...
>>
>>> 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 <at>yahoo<dot>com for email
>>>> -----------------------------------------------------
>>>>
>>>>
>>>
>>> --
>>> Cheers
>>> Andy
>>>
>>> ------
>>> Andy Pope, Microsoft MVP - Excel
>>> http://www.andypope.info
>>>
>>
>>
>>
>

Urrggh ! I must have been really bat-blind to miss the Chart1, sorry ..

Yes, you're right - the max 72 pts size does help a bit, but it can't reach
the edges.

I'll have a bash at it with the 2 lines suggestion ...

Many thanks, Andy, for your assistance and kind offer !

--
Rgds
Max
xl 97
----------------------------------------------------
Use xdemechanik <at>yahoo<dot>com for email
-----------------------------------------------------
"Andy Pope" <andy@andypope.info> wrote in message
news:#BhjRJy7DHA.3880@tk2msftngp13.phx.gbl...
> 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 <at>yahoo<dot>com for email
> > -----------------------------------------------------

Marvellous ! That works.

Thanks, Andy and Jon !

--
Rgds
Max
xl 97
----------------------------------------------------
Use xdemechanik <at>yahoo<dot>com for email
-----------------------------------------------------
"Andy Pope" <andy@andypope.info> wrote in message
news:OOIIcfy7DHA.3288@TK2MSFTNGP11.phx.gbl...
> 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/