How do I display a data label (showing the y-value) for a
specific x-value?

If I change the x-value, I want the data label reflect the
new corresponding y-value.

Add the x,y pair as a separate data series

"Jade" <(E-Mail Removed)> wrote in message
news:30ba01c4c010$5aab4500$(E-Mail Removed)...
> How do I display a data label (showing the y-value) for a
> specific x-value?
>
> If I change the x-value, I want the data label reflect the
> new corresponding y-value.

Tried the extra data series - it seems like a good
solution How do I select the new series in order to format
the data labels etc.

>-----Original Message-----
>Add the x,y pair as a separate data series
>
>"Jade" <(E-Mail Removed)> wrote in
message
>news:30ba01c4c010$5aab4500$(E-Mail Removed)...
>> How do I display a data label (showing the y-value) for
a
>> specific x-value?
>>
>> If I change the x-value, I want the data label reflect
the
>> new corresponding y-value.
>
>
>.
>

Jade -

If for any reason the new series isn't visible, you can select another series and
press the up and down arrow keys to cycle the selection among the other series (and
other chart elements). Alternatively you can select it from the chart element
dropdown on the Chart toolbar.

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

Jade wrote:

> Tried the extra data series - it seems like a good
> solution How do I select the new series in order to format
> the data labels etc.
>
>
>>-----Original Message-----
>>Add the x,y pair as a separate data series
>>
>>"Jade" <(E-Mail Removed)> wrote in
>
> message
>
>>news:30ba01c4c010$5aab4500$(E-Mail Removed)...
>>
>>>How do I display a data label (showing the y-value) for
>
> a
>
>>>specific x-value?
>>>
>>>If I change the x-value, I want the data label reflect
>
> the
>
>>>new corresponding y-value.
>>
>>
>>.
>>