B
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
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