View Single Post
  #4  
Old March 27th, 2010, 07: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.

.