Double click the data labels, on the Number tab apply the desired
format, then make sure the Linked to Source box is not checked.

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


TJB wrote:

One set of data being plotted. A $ value for a particular day and the chart
covers a five year period. The X data is the date format "*3/14/2001" and
the Y data in the $ format.

"bj" wrote:


Do you have just one data set or several being plotted. What is the format
of the input X data?

"TJB" wrote:


Since my chart is a daily chart over a few years, I don't have data labels
displayed on my chart. However, the user can run their curser over a point
on the chart and it will display the date and value at that point. My
problem is the date is sometimes displayed in it's numeric equivalent (i.e
"38546") and other times it actually displays the date (7/13/05). How can I
stop the chart from displaying the numeric equivalent? I can't figure out
why sometimes the date shows and somtimes the numeric equivalent shows.

Thanks!