• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

3D Map Hourly Timeline don't come correctly


New Member
I'm trying since yesterday to make 3D heat map with hourly timeline
but always Date don't come correctly - I tried different cell format but still couldn't fix it

*Attached is my workbook, correct date format should be as in Excel column A & B
but in 3D map it show date of 99

if some expert knows how to fix it, it will be great



Excel Ninja
Staff member
Add a field to your data called Date2 or anything else
Make that field =A2+B2

Then in the 3D map
Refresh data
Then drag the new field name from the Field Picker into the Time dropdown


Time without a date assumes that the year is 0
  • Like
Reactions: H.H