ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Scrolling Along Chart (https://www.excelbanter.com/excel-discussion-misc-queries/171798-scrolling-along-chart.html)

F. Lawrence Kulchar

Scrolling Along Chart
 
Often, but not always, when I scroll along my chart data line to examine
data, my date information often comes out like this:

"7 day" point "39445" Value:141

In other words, my date "39445" is not shown as "Dec. 30"??
The "39445" represents "Dec. 30" formatted as a number!

Why does "Dec. 30" not appear?


Thanks,

FLKulchar



Wigi

Scrolling Along Chart
 
Did you really format everything properly?


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"F. Lawrence Kulchar" wrote:

Often, but not always, when I scroll along my chart data line to examine
data, my date information often comes out like this:

"7 day" point "39445" Value:141

In other words, my date "39445" is not shown as "Dec. 30"??
The "39445" represents "Dec. 30" formatted as a number!

Why does "Dec. 30" not appear?


Thanks,

FLKulchar



All times are GMT +1. The time now is 08:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com