Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 01-30-2018, 03:16 AM
p45cal's Avatar
p45cal p45cal is offline How do I get Excel to format dates on graph? Windows 10 How do I get Excel to format dates on graph? Office 2010 32bit
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

The cells can be set to any date format, if the cell doesn't contain a date you just see the text. The biggest clue from your screenshots that some of these are unlikely to be dates is that youv'e chosen a date format that should show the full month name yet the Sample field still shows a 3-letter month - a sure sign that Excel hasn't recognised it as a date. This is what it should look like:



To check if a cell has an Excel date (a number) in it, open the cell formatting dialogue box and choose General in the Category list and you should see a number in the Sample box:


(You don't need to close the box with OK, you can just Esc out of it without changing anything.)
In your case, I'd select all the dates in the top row, open the cell formatting dialogue box and convert them all to General. All the non-dates will show up as text, so you just need to re-enter those dates in an Excel-recognisable format. Excel will try to be helpful and if it recognises a newly-entered value as a date it will format it for you in some date format so to double check they're all dates again you'll have to convert them all to General again. Once they're all dates, format them as you will and your charts should be OK.
Attached Images
File Type: jpg Capture3.JPG (21.7 KB, 52 views)
File Type: jpg Capture3a.JPG (26.5 KB, 50 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a simple graph with a list of dates at the bottom? MRnightmuffin Excel 1 01-18-2018 06:48 PM
How do I get Excel to format dates on graph? Format cells dependent on given dates fizzwolf Excel 1 05-04-2016 09:21 AM
Priority of line graph vs bar graph in terms of front to back positioning on a chart DavePPointuser PowerPoint 1 04-30-2014 10:57 AM
Date Format: how to output dates that are not US? tinfanide Word VBA 0 10-28-2013 03:30 AM
How to change number format of dates ketanco Project 1 09-11-2012 02:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft