Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-28-2017, 03:52 PM
snowboarder2 snowboarder2 is offline Year date not showing at bottom of chart. Windows XP Year date not showing at bottom of chart. Office 2010 32bit
Novice
Year date not showing at bottom of chart.
 
Join Date: Aug 2016
Posts: 26
snowboarder2 is on a distinguished road
Default Year date not showing at bottom of chart.

Numbers on bottom axis shows 1, 2, 3, etc. instead of year of 2002, 2003, 2004, etc.


Dropbox link:
https://www.dropbox.com/s/eb6rgbatrs...Chart.JPG?dl=0

https://www.dropbox.com/s/yqvcebbrg1...Mural.JPG?dl=0
Attached Files
File Type: xlsx Copy of StudentStatusXcel.v9_2005_2014.xlsx (28.9 KB, 8 views)
Reply With Quote
  #2  
Old 02-28-2017, 04:34 PM
jeffreybrown jeffreybrown is offline Year date not showing at bottom of chart. Windows Vista Year date not showing at bottom of chart. Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Please post your worksheet directly here on this site. Some people do not like going out to external sites to download stuff.
Reply With Quote
  #3  
Old 02-28-2017, 04:36 PM
snowboarder2 snowboarder2 is offline Year date not showing at bottom of chart. Windows XP Year date not showing at bottom of chart. Office 2010 32bit
Novice
Year date not showing at bottom of chart.
 
Join Date: Aug 2016
Posts: 26
snowboarder2 is on a distinguished road
Default

Quote:
Originally Posted by jeffreybrown View Post
Please post your worksheet directly here on this site.
I'd be glad to, but when I click on the image icon it asks for a link instead of the image? I'm not sure how to upload images on this forum.
Reply With Quote
  #4  
Old 02-28-2017, 04:37 PM
jeffreybrown jeffreybrown is offline Year date not showing at bottom of chart. Windows Vista Year date not showing at bottom of chart. Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Click on edit post >> Go advanced >> and manage attachments

https://www.msofficeforums.com/faq.p...b3_attachments
Reply With Quote
  #5  
Old 02-28-2017, 05:13 PM
jeffreybrown jeffreybrown is offline Year date not showing at bottom of chart. Windows Vista Year date not showing at bottom of chart. Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

You didn't set a horizontal axis...

Right Click chart >> select Data
Select Edit on the horizontal axis
Axis label range: ='Tables & Charts'!$A$3:$A$9

Not sure why you have the Year as a series? Seems as that could be removed which would leave you with just Extramural Funding as the solo series
Attached Files
File Type: xlsx Copy of StudentStatusXcel.v9_2005_2014.xlsx (26.8 KB, 10 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Year date not showing at bottom of chart. Trying to generate a Documents with the date for every day of the year. RLAlura Mail Merge 2 01-28-2016 02:57 PM
Excel day date month year Function greginky Excel 1 01-05-2016 02:19 AM
How to calculate a rolling year-to-date percentage by quarter as the year progresses sleake Excel Programming 2 04-23-2015 11:51 AM
Inserting “date & time” for the year (YYYY) only, Jamal NUMAN Word 5 07-19-2014 06:42 PM
Year date not showing at bottom of chart. Word Issue, bottom of document is showing on the screen several times. TerryBlevins Word 1 12-21-2011 12:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:26 AM.


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