Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2015, 12:18 PM
MARENG MARENG is offline X axis does not show Years from data Windows Vista X axis does not show Years from data Office 2007
Novice
X axis does not show Years from data
 
Join Date: Feb 2011
Location: England
Posts: 4
MARENG is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Garden 2009 onwards Yields.xlsx (77.6 KB, 16 views)
Reply With Quote
  #2  
Old 01-19-2015, 07:21 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline X axis does not show Years from data Windows 7 64bit X axis does not show Years from data Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Select your graph
Select the "Design tab" under the new Chart Tools ribbon
Click "Swith Row/column" twice
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 01-19-2015, 07:23 AM
gebobs gebobs is offline X axis does not show Years from data Windows 7 64bit X axis does not show Years from data Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Like this?
Attached Files
File Type: xlsx Garden 2009 onwards Yields.xlsx (66.8 KB, 8 views)
Reply With Quote
  #4  
Old 01-19-2015, 09:35 AM
MARENG MARENG is offline X axis does not show Years from data Windows Vista X axis does not show Years from data Office 2007
Novice
X axis does not show Years from data
 
Join Date: Feb 2011
Location: England
Posts: 4
MARENG is on a distinguished road
Default

Gebobs,
Thank you, that worked on that particular graph, but not on one I put together today, in fact there was no change.
It would appear that MS is removing functionality from the Office in little ways like this.

At one time whatever values you had in the XY columns appeared on your graph axis, but not now. Previously I used to put the date but over time MS corrupted that now I just use the nmber to represent the date and now that doesn't work.

It would appear that the functions on Excel now are there to allow you to make a pretty picture rather than construct a mathematical device as it was intended.
I have noticed that sometimes the Trend function is greyed out and cannot be used.

So what do I do next?
Reply With Quote
  #5  
Old 01-19-2015, 09:47 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline X axis does not show Years from data Windows 7 64bit X axis does not show Years from data Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Tried my post?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #6  
Old 01-19-2015, 10:51 AM
MARENG MARENG is offline X axis does not show Years from data Windows Vista X axis does not show Years from data Office 2007
Novice
X axis does not show Years from data
 
Join Date: Feb 2011
Location: England
Posts: 4
MARENG is on a distinguished road
Default X axis Does Not show data from X column

Yes that worked on my original graph, but on a new graph for something else completely different it didn't work.
You will note in jpeg XL that the numbers show in the window, but after carrying out the change of name for the series it reverts back (XL2) to as shown on the X axis.

Should not the data on the axis represent the data you are highlighting to construct the graph in the first place?
Attached Images
File Type: jpg XL.jpg (114.7 KB, 16 views)
File Type: jpg XL2.jpg (152.9 KB, 15 views)
Reply With Quote
  #7  
Old 01-20-2015, 06:26 AM
gebobs gebobs is offline X axis does not show Years from data Windows 7 64bit X axis does not show Years from data Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

I presume you are selecting the data and then inserting a chart. For some reason that I have not been able to figure out, sometimes Excel doesn't interpret the leftmost column of data as the x-axis labels. More often than not, it interprets it as another data series and the default x-axis labels are an integer series (i.e. 1,2,3,...). This is what I found to be the case in the example from your original post.

To fix this, you have to:
* delete remove the series that should be the x-axis labels from the Legend Entries
* edit the Horizontal Axis Labels so that it uses the range you want.

I haven't tried Peco's workaround yet, but that may be a shortcut. Of course, like mine, it is just that...a workaround. It would be nice if we could find out how to set Excel to do this automatically. It seems that it should, at least from my viewpoint, since this is the way I always make charts. How many times do you make charts that simply use an integer series axis?
Reply With Quote
  #8  
Old 01-20-2015, 06:35 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline X axis does not show Years from data Windows 7 64bit X axis does not show Years from data Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Maybe there is help at this site
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #9  
Old 01-20-2015, 10:45 AM
MARENG MARENG is offline X axis does not show Years from data Windows Vista X axis does not show Years from data Office 2007
Novice
X axis does not show Years from data
 
Join Date: Feb 2011
Location: England
Posts: 4
MARENG is on a distinguished road
Default

Thank you Gebobs, that worked. I have always highlighted the colums of figures and then gone to Insert Graph even going back to the days of Lotus 1-2-3, Works Spreadsheet and early versions of Windows Excel, in fact the older versions of Excel did what you expected them to do, but this 'ribbon' system only seems to concentrate on making a pretty picture and tends to be a bit hairy fairy to my liking.
You feel like a real muppet not being able to construct a simple graph, when you have been doing it for 25 years with older systems.
Thank you for your help.
Reply With Quote
Reply

Tags
graphs, x axis, years

Thread Tools
Display Modes


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
X axis does not show Years from data 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:17 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