Forum Discussion
Strange Dates Showing Up in Graph
Hey, So recently I've been working on analytical data, but I've run into a strange problem during graphing. My data is organized by the date, so when I go to graph I try to graph with that. The prob...
As variant dates are not added as X axis, thus you have sequential numbers instead.
If you apply Date format to axis it'll be like
since dates are just numbers starting from 1 which is equal to Jan 01, 1900.
I need a sample excel file to help you