2 questions

[assaf1978]

Hi,
No. 1: I have 3 values (60,42,33). I would like to have a line that connects
them but it will drop with a 90 degrees angle from 60 to 42 on x=42 and from
42 to 33 on x=33.

No. 2 : Is there an option to have the tool tip show a specific text for
each point, I mean, if I have comments for every point, can I show them in
the tool tip when I hover over that point?

Thanks,
Assaf.

 

[Dave Curtis]

Hi,
It sounds like you're after a step chart.
Try Jon Peltier's site for some examples.
Dave

 

[assaf1978]

Thanks, What about no. 2?

Hi,
It sounds like you're after a step chart.
Try Jon Peltier's site for some examples.
Dave

 

[Dave Curtis]

Hi,
I think you'll need VBA for that. I don't know whether it can be done.
My alternative is to use data labels linked to checkboxes, enabling you to
turn the data labels on or off, individually if necessary.

Dave

 

[Andy Pope]

Hi,

You could try Tushar's addin.
http://tushar-mehta.com/excel/software/chart_hover_label/index.html

Cheers
Andy