Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2016, 05:57 AM
Dyeaton Dyeaton is offline Excel: Dates in a chart Mac OS X Excel: Dates in a chart Office for Mac 2011
Novice
Excel: Dates in a chart
 
Join Date: Oct 2016
Posts: 2
Dyeaton is on a distinguished road
Default Excel: Dates in a chart

Part 1 - Started a data list date as 9/1/2016. I now want to show the date as 9/1, however, when the date is changed it resets back to the 9/1/2016 format. How can I use the 9/1 date format?



Part 2: I want to engage a chart to full letter page size when the chart is printed. However, when I drag the corner of the chart to enlarge it addition (and unwanted) dates appear. How can I enlarge the chart without showing unwanted dates?

Thanks,

Dyeaton
Reply With Quote
  #2  
Old 10-18-2016, 08:11 AM
Esaylikepie Esaylikepie is offline Excel: Dates in a chart Windows 10 Excel: Dates in a chart Office 2016
Novice
 
Join Date: Oct 2016
Posts: 5
Esaylikepie is on a distinguished road
Default

If you create a column with your dates (or row), 9/1, 9/2, 9/3 ect, select all your data points and then right click > go 'Format Cells' > select the 'Number' tab > Select category 'General', that I would assume should fix the issue of your input reverting back to 9/1/2016 ect...

RE your second question, have you tried turning off the 'Data Labels'? Click on the graph, and if you have excel ED 2013, click the green arrow that appears at the top right of the graph, deselect 'Data Labels'
Reply With Quote
  #3  
Old 10-19-2016, 05:03 AM
Dyeaton Dyeaton is offline Excel: Dates in a chart Mac OS X Excel: Dates in a chart Office for Mac 2011
Novice
Excel: Dates in a chart
 
Join Date: Oct 2016
Posts: 2
Dyeaton is on a distinguished road
Default Excel Data Labels

Easyaspie

Thanks for responding to my questions.

Your response for the 1st question solved the problem.

However, I can't use your 2nd suggestion, I do not have the ED 2013 of Excel.

I do have the following edition: "Mac 2011 v. 14.6.8.

I cannot find "Data Labels" in my Excel version; can you suggest how to find "Data Labels"?

Thanks,

Dyeaton
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Skipping dates with no data in chart. c991257 Excel 0 08-09-2016 11:55 PM
Proportionally spread dates on chart x-axis? jhoby Excel 0 06-07-2015 01:04 PM
Dates from Excel into Outlook MrAdamRe Outlook 4 03-17-2015 06:10 AM
Excel: Dates in a chart Excel is changing dates. laqa Excel 5 11-06-2014 07:26 PM
Update a summary chart when I update a dashboard with dates cangelis Excel 6 09-24-2014 08:08 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 09:53 AM.


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