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
|
|||
|
|||
Trying to change x-axis date range
I have a scatter chart with dates on the x-axis and data on the y. When
trying to change the range of my x-axis, I right click on the x-axis, click "format axis" and for "Minimum" and "Maximum" I click "Fixed" but it will only let me enter dates in the number format (i.e. 39983 instead of 6/19/2009). This is really annoying because I am constantly changing ranges to zoom in on the data and need to think about what the number format would be. I didn't have this problem with the earler version of excel (2003), but it started as soon as my office upgraded to 2007. Any ideas? |
#2
|
|||
|
|||
Trying to change x-axis date range
Hi,
The ability to enter dates directly, although not time, is fixed in Service pack 2. http://office.microsoft.com/en-gb/do...s/default.aspx Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "jschultzbass" wrote in message ... I have a scatter chart with dates on the x-axis and data on the y. When trying to change the range of my x-axis, I right click on the x-axis, click "format axis" and for "Minimum" and "Maximum" I click "Fixed" but it will only let me enter dates in the number format (i.e. 39983 instead of 6/19/2009). This is really annoying because I am constantly changing ranges to zoom in on the data and need to think about what the number format would be. I didn't have this problem with the earler version of excel (2003), but it started as soon as my office upgraded to 2007. Any ideas? |
#3
|
|||
|
|||
Trying to change x-axis date range
I downloaded and installed Service Pack 2 but it didn't seem to make a
difference. Any other suggestions? "Andy Pope" wrote: Hi, The ability to enter dates directly, although not time, is fixed in Service pack 2. http://office.microsoft.com/en-gb/do...s/default.aspx Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "jschultzbass" wrote in message ... I have a scatter chart with dates on the x-axis and data on the y. When trying to change the range of my x-axis, I right click on the x-axis, click "format axis" and for "Minimum" and "Maximum" I click "Fixed" but it will only let me enter dates in the number format (i.e. 39983 instead of 6/19/2009). This is really annoying because I am constantly changing ranges to zoom in on the data and need to think about what the number format would be. I didn't have this problem with the earler version of excel (2003), but it started as soon as my office upgraded to 2007. Any ideas? |
#4
|
|||
|
|||
Trying to change x-axis date range
Hi,
My bad. Looks like they only fixed dates on line/column/bar charts and not xy-scatter, which I assume is what your chart type is. Looks like you will have to use a cell formatted as number to get the correct value. Cheers Andy jschultzbass wrote: I downloaded and installed Service Pack 2 but it didn't seem to make a difference. Any other suggestions? "Andy Pope" wrote: Hi, The ability to enter dates directly, although not time, is fixed in Service pack 2. http://office.microsoft.com/en-gb/do...s/default.aspx Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "jschultzbass" wrote in message ... I have a scatter chart with dates on the x-axis and data on the y. When trying to change the range of my x-axis, I right click on the x-axis, click "format axis" and for "Minimum" and "Maximum" I click "Fixed" but it will only let me enter dates in the number format (i.e. 39983 instead of 6/19/2009). This is really annoying because I am constantly changing ranges to zoom in on the data and need to think about what the number format would be. I didn't have this problem with the earler version of excel (2003), but it started as soon as my office upgraded to 2007. Any ideas? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
Trying to change x-axis date range
Andy, that doesn't work either. When I change the chart type to number, it
just remains as number. I'm wondering what changed in 2007 that prevents a person from simply entering in a date and having the date remain instead of going back to a numerical sequence. Thanks in advance. "Andy Pope" wrote: Hi, My bad. Looks like they only fixed dates on line/column/bar charts and not xy-scatter, which I assume is what your chart type is. Looks like you will have to use a cell formatted as number to get the correct value. Cheers Andy jschultzbass wrote: I downloaded and installed Service Pack 2 but it didn't seem to make a difference. Any other suggestions? "Andy Pope" wrote: Hi, The ability to enter dates directly, although not time, is fixed in Service pack 2. http://office.microsoft.com/en-gb/do...s/default.aspx Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "jschultzbass" wrote in message ... I have a scatter chart with dates on the x-axis and data on the y. When trying to change the range of my x-axis, I right click on the x-axis, click "format axis" and for "Minimum" and "Maximum" I click "Fixed" but it will only let me enter dates in the number format (i.e. 39983 instead of 6/19/2009). This is really annoying because I am constantly changing ranges to zoom in on the data and need to think about what the number format would be. I didn't have this problem with the earler version of excel (2003), but it started as soon as my office upgraded to 2007. Any ideas? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
|
|||
|
|||
Trying to change x-axis date range
What I meant was in order to know what value to use instead of a date was to
enter the required date in a cell and then change the number format of the cell. This will then display the value So for your example Enter 6/19/2009 Change to number in order to reveal 39983 You will then manually have to enter the value to set the scale. All of the charting section changed in xl2007, it was completely re-written. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "G" wrote in message ... Andy, that doesn't work either. When I change the chart type to number, it just remains as number. I'm wondering what changed in 2007 that prevents a person from simply entering in a date and having the date remain instead of going back to a numerical sequence. Thanks in advance. "Andy Pope" wrote: Hi, My bad. Looks like they only fixed dates on line/column/bar charts and not xy-scatter, which I assume is what your chart type is. Looks like you will have to use a cell formatted as number to get the correct value. Cheers Andy jschultzbass wrote: I downloaded and installed Service Pack 2 but it didn't seem to make a difference. Any other suggestions? "Andy Pope" wrote: Hi, The ability to enter dates directly, although not time, is fixed in Service pack 2. http://office.microsoft.com/en-gb/do...s/default.aspx Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "jschultzbass" wrote in message ... I have a scatter chart with dates on the x-axis and data on the y. When trying to change the range of my x-axis, I right click on the x-axis, click "format axis" and for "Minimum" and "Maximum" I click "Fixed" but it will only let me enter dates in the number format (i.e. 39983 instead of 6/19/2009). This is really annoying because I am constantly changing ranges to zoom in on the data and need to think about what the number format would be. I didn't have this problem with the earler version of excel (2003), but it started as soon as my office upgraded to 2007. Any ideas? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|