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!
@irrelevant22352 жыл бұрын
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!
@elizabethsmead38816 жыл бұрын
So so helpful! Been trying to figure it out for hours!
@dilmawijenayake5 ай бұрын
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.
@marianapio34562 жыл бұрын
THANK YOU!! You saved my life!!
@yigitalpkaynak Жыл бұрын
Thanks for the brief explanation!
@eclipseslayer9810 күн бұрын
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.
@LocherYT3 ай бұрын
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
@rickmathews11542 жыл бұрын
Thanks Bro, huge help
@nikhilshah81424 жыл бұрын
absolute legend, cheers mate
@kimberlymedina55732 жыл бұрын
Very helpful. Thank you!
@danielrecord19194 жыл бұрын
Thanks you save my day! :D
@jackstraw55273 жыл бұрын
So freaking helpful. Thank you!
@jasonrosenbaum8614 жыл бұрын
Thank you! HUGE help!
@justindougherty976 Жыл бұрын
THANK YOU!!!!!!!!
@1687adrian3 жыл бұрын
thanks... right on the problem
@ifeanyimichael87732 жыл бұрын
Thanks for this video but please how do we separate time and plot the time in a graph 📊
@VolatileGuy1032 ай бұрын
thanks
@vincentmarotta98006 ай бұрын
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.
@andrewsladky74623 жыл бұрын
THANK YOU SO MUCH!!
@Rohrpost3 жыл бұрын
the solution shown only works if you always have the same time distance between Y values.
@Sinflair2 жыл бұрын
I think you mean x values but yeah you are right. Did you figure out how to graph if with uneven x values?
@apmgold3 жыл бұрын
Anyone know how to solve the same problem on a MAC Thanks, in anticipation
@yangyang60083 жыл бұрын
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?
@sehamatia45523 жыл бұрын
you fix it ? I don't found the axis type option
@weshelwig20192 жыл бұрын
It'd be nice is microsoft streamlined how to do common sense things in excel rather than rearranging the tool bar version after version.