A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I extend the X-axis in Excel2007



 
 
Thread Tools Display Modes
  #1  
Old March 10th, 2010, 11:42 PM posted to microsoft.public.excel.charting
Jim26
external usenet poster
 
Posts: 6
Default How do I extend the X-axis in Excel2007

I have a line graph of accounts on the Y-axis, plotted against months on the
x-axis.
I extended the axis for 2008 (in Excel 2000), I now want to extend it again
for 2010, but I am having trouble.
  #2  
Old March 11th, 2010, 12:30 AM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
 
Posts: 516
Default How do I extend the X-axis in Excel2007

This is how I would do it
Open the x-axis format dialog and open first tab 'Axis Options'
In the first two items set the smallest and highest x-axis label value
Type in a 2010 date as needed
Is this what you tried?
Do you have a Line or an XY chart?
Excel 2007 had problems with setting limits in an XY chart when the values
are dates.
Here is the workaround: type the required date into a cell on the worksheet
(say 31-dec-2010)
Now format that cell General to get the date serial number (40543)
Enter this 5 digit number into the box in the axis format dialog rather than
an actual date
The problem is fixed in Excel 2010 beta
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Jim26" wrote in message
...
I have a line graph of accounts on the Y-axis, plotted against months on
the
x-axis.
I extended the axis for 2008 (in Excel 2000), I now want to extend it
again
for 2010, but I am having trouble.


  #3  
Old March 12th, 2010, 01:49 PM posted to microsoft.public.excel.charting
AdamV[_2_]
external usenet poster
 
Posts: 38
Default How do I extend the X-axis in Excel2007

Are you actually trying to get it to include more data? Or have you
added the data but it is not showing up on the chart due to a truncated
axis?
It sounds to me like the first one, in which case you need to go to the
Chart Tools|Design ribbon and click the Select Data button (or right
click the chart and choose this).
Find the relevant series in the list on the left, select it and then
click on edit button.
Change the range defined for the series values in the second box (either
by hand, changing the column or row number as appropriate, or by
re-selecting the correct range)

OK to everything

Hope this helps.
Adam

On 10/03/2010 22:42, Jim26 wrote:
I have a line graph of accounts on the Y-axis, plotted against months on the
x-axis.
I extended the axis for 2008 (in Excel 2000), I now want to extend it again
for 2010, but I am having trouble.

  #4  
Old March 27th, 2010, 08:41 PM posted to microsoft.public.excel.charting
Jim26
external usenet poster
 
Posts: 6
Default How do I extend the X-axis in Excel2007

Finally getting back to my problem. I had selected the data range as
suggested by AdemV, but the graph was still truncated. I finally formatted
the horizontal axis as suggested by Bernard and solved the problem. I should
have known that. Thanks for the help guys.

"AdamV" wrote:

Are you actually trying to get it to include more data? Or have you
added the data but it is not showing up on the chart due to a truncated
axis?
It sounds to me like the first one, in which case you need to go to the
Chart Tools|Design ribbon and click the Select Data button (or right
click the chart and choose this).
Find the relevant series in the list on the left, select it and then
click on edit button.
Change the range defined for the series values in the second box (either
by hand, changing the column or row number as appropriate, or by
re-selecting the correct range)

OK to everything

Hope this helps.
Adam

On 10/03/2010 22:42, Jim26 wrote:
I have a line graph of accounts on the Y-axis, plotted against months on the
x-axis.
I extended the axis for 2008 (in Excel 2000), I now want to extend it again
for 2010, but I am having trouble.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.