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. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|