Excel Graphing with Dates

[@brittanybadal3721]

I have spent hours trying to figure this out, including watching numerous KZbin videos ... and you helped me solve my issue in 2 minutes and 21 seconds. THANK YOU!

[@irrelevant2235]

This horizontal axis date issue was driving me nuts. Your video was very helpful! Thank you very much for posting it!

[@neuberry]

Thank you, Josh, it worked perfectly with Excel for Mac v 16.7. Now I have to ice the lump on my forehead. With such a common requirement, you'd think Excel would default to actual dates.

[@dr.joshuawilson5810]

Glad it worked!

[@elizabethsmead3881]

So so helpful! Been trying to figure it out for hours!

[@dilmawijenayake]

Thank you very much❤.. I tried like 100 times, and then I watched your video.. I did in a second 😅

[@willyg7394]

Thank you so very much!!! This is so very helpful!!!

[@ShannonSettles]

I guess you didn’t notice changing the axis to text completely changed your chart? I suspect all your data points are evenly spaced and no longer proportional to the dates the data was recorded.

[@chrissupport]

I suppose that's what he wanted. I'll usually want data points proportional to actual time (shows dates with tick marks every 14 days on mine). Thanks.. I hadn't thought of this.

[@marianapio3456]

THANK YOU!! You saved my life!!

[@yigitalpkaynak]

Thanks for the brief explanation!

[@eclipseslayer98]

I tried to do this, but my dates are stuck in the Y axis, or don;t exist when in the X axis. There's also no, "text axis" option.

[@LocherYT]

I still cant figure it out. I did everything as shown in this video but my values column becomes the chart title, and the charted graph only has one entry for the bottom date

[@mynameisnot9524]

Didnt work, it just jumbled up all my dates into an unreadable mess

[@rickmathews1154]

Thanks Bro, huge help

[@nikhilshah8142]

absolute legend, cheers mate

[@kimberlymedina5573]

Very helpful. Thank you!

[@danielrecord1919]

Thanks you save my day! :D

[@jackstraw5527]

So freaking helpful. Thank you!

[@jasonrosenbaum861]

Thank you! HUGE help!

[@justindougherty976]

THANK YOU!!!!!!!!

[@1687adrian]

thanks... right on the problem

[@ifeanyimichael8773]

Thanks for this video but please how do we separate time and plot the time in a graph 📊

[@VolatileGuy103]

thanks

[@vincentmarotta9800]

Note: Due to Excel just deciding this is the way it needs to be, this "Axis Type" option ONLY appears when you use a LINE, and NOT with Scatter plot. This is ridiculous. Why can't I date scatter points? Even if they're crushed together, I should at least be able to see the range of dates on the x-axis. Fix this, Excel. Don't choose to be this way.

[@andrewsladky7462]

THANK YOU SO MUCH!!

[@Rohrpost]

the solution shown only works if you always have the same time distance between Y values.

[@Sinflair]

I think you mean x values but yeah you are right. Did you figure out how to graph if with uneven x values?

[@apmgold]

Anyone know how to solve the same problem on a MAC Thanks, in anticipation

[@yangyang6008]

I notice that if you try to plot a "scatter with smooth lines", then the option "Axis Type" will become unavailable. Can anyone fix this as well?

[@sehamatia4552]

you fix it ? I don't found the axis type option

[@weshelwig2019]

It'd be nice is microsoft streamlined how to do common sense things in excel rather than rearranging the tool bar version after version.

[@kushwanth.g4599]

So 🙏🙏