Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default To mark points when function reach some values

I want to mark points when function reach some values on chart. Is that
posible?

Thanks for help!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default To mark points when function reach some values


I want to mark points when function reach some values on chart. Is that
posible?

Thanks for help!


Yes it is!

a) But i dont know how and b) u have to specify in which way do u want to
mark that points.

With an arrow? Bold up?

greets mt


  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default To mark points when function reach some values

Hi,

You can do this by add extra data series that has points that are only
displayed when required.

This page has some examples and further links
http://www.andypope.info/charts/Labellast.htm

Cheers
Andy

natash@ wrote:
I want to mark points when function reach some values on chart. Is that
posible?

Thanks for help!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default To mark points when function reach some values

Here's another example of Andy's suggestion:

http://peltiertech.com/Excel/Charts/...nalChart1.html

Alternatively, you could try something like this:

http://peltiertech.com/Excel/Charts/PointAtPoints.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"natash@" wrote in message
...
I want to mark points when function reach some values on chart. Is that
posible?

Thanks for help!



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
Using Match function with duplicate values in an array Richard Excel Worksheet Functions 3 April 22nd 23 07:45 PM
Multiple If function for more than 7 values echo_park Excel Worksheet Functions 6 August 7th 06 03:41 PM
CHOOSE function - Possible with 100 values??? Fecozisk Excel Discussion (Misc queries) 1 July 12th 06 09:22 AM
Lookup function gives wrong values occasionally [email protected] Excel Discussion (Misc queries) 3 July 1st 06 12:58 AM
need to save values from a function before it changes Ron Excel Worksheet Functions 1 October 29th 04 06:29 AM


All times are GMT +1. The time now is 10:13 PM.

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

About Us

"It's about Microsoft Excel"