A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Focus / Targeting Lines on a Chart



 
 
Thread Tools Display Modes
  #11  
Old February 9th, 2004, 05:27 PM
Andy Pope
external usenet poster
 
Posts: n/a
Default 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

  #12  
Old February 10th, 2004, 03:05 PM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default Focus / Targeting Lines on a Chart

I assume that between the suggestions here and in the PP NG, this is no
longer an issue. However, if it is, check the Excel/Add-
Ins/Interactive Chart page of my web site for an add-in that does
something very similar.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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 atyahoodotcom for email
-----------------------------------------



  #13  
Old February 10th, 2004, 05:00 PM
Max
external usenet poster
 
Posts: n/a
Default Focus / Targeting Lines on a Chart

Thanks, Tushar.

But no, you're wrong g.
Even when it is no longer a pressing issue,
any options offered are always welcome & appreciated.

ok, I've checked out your Interactive Chart page

Certainly looks promising. Would have liked to try it out.
but think unable? to proceed further as I'm using xl97 [& PPT97].

There's this little caveat at the top right of the page:
"Works with Excel 2000 (or later) only."

Any equivalent add-in for xl97 ?

--
Rgds
Max
xl 97
----------------------------------------------------
Use xdemechanik atyahoodotcom for email
-----------------------------------------------------
"Tushar Mehta" wrote in message
news:MPG.1a92af466cf53c929896c0@news-server...
I assume that between the suggestions here and in the PP NG, this is no
longer an issue. However, if it is, check the Excel/Add-
Ins/Interactive Chart page of my web site for an add-in that does
something very similar.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions



  #14  
Old February 11th, 2004, 07:35 PM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default Focus / Targeting Lines on a Chart

Off the top of my head I can't think of any reason why it is restricted
to XL2000+. I'll have to take a look at it.

It's just amazing how many people/companies are still using Office 97.
Says a lot about the value of Office 2000, 2002, and 2003! g

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Thanks, Tushar.

But no, you're wrong g.
Even when it is no longer a pressing issue,
any options offered are always welcome & appreciated.

ok, I've checked out your Interactive Chart page

Certainly looks promising. Would have liked to try it out.
but think unable? to proceed further as I'm using xl97 [& PPT97].

There's this little caveat at the top right of the page:
"Works with Excel 2000 (or later) only."

Any equivalent add-in for xl97 ?

--
Rgds
Max
xl 97
----------------------------------------------------
Use xdemechanik atyahoodotcom for email
-----------------------------------------------------
"Tushar Mehta" wrote in message
news:MPG.1a92af466cf53c929896c0@news-server...
I assume that between the suggestions here and in the PP NG, this is no
longer an issue. However, if it is, check the Excel/Add-
Ins/Interactive Chart page of my web site for an add-in that does
something very similar.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions




  #15  
Old February 12th, 2004, 01:53 PM
Max
external usenet poster
 
Posts: n/a
Default Focus / Targeting Lines on a Chart

Ahh, I'll have to keep my fingers crossed for a possible version for xl97,
then ? g

Anyway, boldy (or brazenly?) ignoring the caveat,
just tried loading the "Interactive Chart Display" add-in into xl97
via Tools Add-ins. It showed up as one of the add-ins available
but it just won't load.

Hit an error immediately:
Compile error in hidden module: InterpFormulas

Looks like the caveat was accurate ..

--
Rgds
Max
xl 97
----------------------------------------------------
Use xdemechanik atyahoodotcom for email
-----------------------------------------------------
"Tushar Mehta" wrote in message
news:MPG.1a943fff945ad4be9896cc@news-server...
Off the top of my head I can't think of any reason why it is restricted
to XL2000+. I'll have to take a look at it.

It's just amazing how many people/companies are still using Office 97.
Says a lot about the value of Office 2000, 2002, and 2003! g

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions



  #17  
Old February 12th, 2004, 11:00 PM
Max
external usenet poster
 
Posts: n/a
Default Focus / Targeting Lines on a Chart

Many thanks, Tushar !

--
Rgds
Max
xl 97
----------------------------------
Use xdemechanik atyahoodotcom for email
-----------------------------------------
"Tushar Mehta" wrote in message
news:MPG.1a955f888f09de3b9896ce@news-server...
Sorry. It turned out to be something more than a false warning. But,
your polite persistence paid off. Check version 1.1m. It's
retrofitted to XL97!

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions



  #18  
Old February 13th, 2004, 01:37 AM
Max
external usenet poster
 
Posts: n/a
Default Focus / Targeting Lines on a Chart

Many thanks, Tushar !

A god-send to the XL97 fraternity...

--
Rgds
Max
xl 97
----------------------------------
Use xdemechanik atyahoodotcom for email
-----------------------------------------
"Tushar Mehta" wrote in message
news:MPG.1a955f888f09de3b9896ce@news-server...
Sorry. It turned out to be something more than a false warning. But,
your polite persistence paid off. Check version 1.1m. It's
retrofitted to XL97!

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions



  #19  
Old February 13th, 2004, 04:47 AM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default Focus / Targeting Lines on a Chart



You are welcome. Glad to be of help.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Many thanks, Tushar !

A god-send to the XL97 fraternity...

--
Rgds
Max
xl 97
----------------------------------
Use xdemechanik atyahoodotcom for email
-----------------------------------------
"Tushar Mehta" wrote in message
news:MPG.1a955f888f09de3b9896ce@news-server...
Sorry. It turned out to be something more than a false warning. But,
your polite persistence paid off. Check version 1.1m. It's
retrofitted to XL97!

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.