• 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

    Hui...

  • 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

H.H

New Member
Dears,
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
 

Attachments

Hui

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
76215

Enjoy

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