Cursor over data point on Excel Chart

[Brad Reid]

For an x-y graph in Excel where the x values are dates and the y values are
stock data, I have formatted it so I see the dates along the horizontal x
axis. All good so far, but when I place my cursor pointer over a data
point, it flashes up the numeric value for the date, then the price point
like this:

(37934, 1254)

I wonder if there is a formatting technique to force it to show the date in
date format. It would be easier for me to identify a particular date since
I space out the date labels along the axis and can't determine with
precision the exact date of a point I've placed the cursor over. I guess if
I had one of those "savant" math qualities, my mind could make the
calculation on the fly, but, in the absence of that skill, is there a way to
format these little pop-up boxes??? Thanks, Brad

 

[Jon Peltier]

Brad -

I tried Scatter charts, Line charts with time-scale X axes, and Line
charts with category X axes. What I found is that no matter which chart
type, and no matter which axis type in the Line charts, if my worksheet
cells are formatted as dates, the chart tips show me dates. And if my
worksheet cells are formatted a General (or other non-dates), I get the
37848 style serial date in the chart tip. Aren't your worksheet cells
formatted as dates?

- Jon