|
|
#1
01-17-2015, 12:18 PM
|
|||
|
|||
X axis does not show Years from data
Simple graph to show Garden Yield (P&L) and other data for each year. Regardless of what the 2009-2014 columns are formatted as the X- axis on the graph does to change to reflect data even after formatting X axis to Automatically Based On Data.
I need the X axis to read 2009-2014 and so on. Tried Formatting 'Year Data' as yyyy under 'special' but this just altered the secondary 'Y' axis to the rhs. Earlier versions of Excel did not have this problem nor does Works Spreadsheet. Please advise. 
|
| Tags |
| graphs, x axis, years |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Expense Projections for 1,3,5,10 years | lynchbro | Excel | 0 | 06-26-2014 08:40 AM |
| how to show identical data once only? | heidiau | Mail Merge | 1 | 09-29-2013 07:44 PM |
| Secondry Axis overlapping in bar chart dual axis in Powerpoint 2010 | sharath_ms | PowerPoint | 0 | 07-08-2013 10:06 PM |
 Show Items with no data
|
DeborahBartlett | Excel | 1 | 01-24-2012 01:10 AM |
| how do I add data values in Col A into X axis on bar graph? | hazz | Excel | 1 | 04-27-2010 01:42 PM |
Windows Vista 
Office 2007
Threaded Mode