#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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' |
#3
|
|||
|
|||
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 |
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 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 |