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
|
|||
|
|||
Time on the X Axis Issue
1. Use an XY chart, not a line chart.
2. Delete the gridlines. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Dave" wrote in message ... Posted this on Excel - no response. Guess I should have been here. I am trying to plot events on a time abscissa. I would like to have the major gridlines at even times, such as 8:00 AM, 9:00 AM, 10:00 AM, 11:00 AM etc. My data, however, occasionally falls in between these times, i.e., 8:05 AM, 9:17 Am, etc. When these points are plotted (correctly), an extra vertical gridline appears automatically at the correct data time. My problem is I don't want that data point gridline to appear. Is there any way I can opt not to get the extra line?? Thx Dave |
#2
|
|||
|
|||
Time on the X Axis Issue
Thank you Jon -
That helps, but the X axis labels continue to match my actual data point times, rather than the even time increments I want. Can we do something about that? BTW, I've been using line charts for years, although I have to admit seldom on time X-axis data. Which has always driven me a bit nuts because of the way the scales want to be set. Whatever. Thx again. Dave "Jon Peltier" wrote in message ... 1. Use an XY chart, not a line chart. 2. Delete the gridlines. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Dave" wrote in message ... Posted this on Excel - no response. Guess I should have been here. I am trying to plot events on a time abscissa. I would like to have the major gridlines at even times, such as 8:00 AM, 9:00 AM, 10:00 AM, 11:00 AM etc. My data, however, occasionally falls in between these times, i.e., 8:05 AM, 9:17 Am, etc. When these points are plotted (correctly), an extra vertical gridline appears automatically at the correct data time. My problem is I don't want that data point gridline to appear. Is there any way I can opt not to get the extra line?? Thx Dave |
#3
|
|||
|
|||
Time on the X Axis Issue
If you get an X axis tick for every data point, either the data is very
regular, or you're still using a line chart. In the first step of the chart wizard, go all the way to the fifth icon down the list, not the third, and make an XY chart. You can get any formatting: with or without lines, with or without markers; the same as in a line chart. But the axis is a true value axis. Also, if Excel recognizes the times as times, it will plot them as such. Problem is, in a line chart, Excel only plots integer values, so all times for a given date are plotted at midnight. In an XY chart, the data is plotted according to value. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Dave" wrote in message ... Thank you Jon - That helps, but the X axis labels continue to match my actual data point times, rather than the even time increments I want. Can we do something about that? BTW, I've been using line charts for years, although I have to admit seldom on time X-axis data. Which has always driven me a bit nuts because of the way the scales want to be set. Whatever. Thx again. Dave "Jon Peltier" wrote in message ... 1. Use an XY chart, not a line chart. 2. Delete the gridlines. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Dave" wrote in message ... Posted this on Excel - no response. Guess I should have been here. I am trying to plot events on a time abscissa. I would like to have the major gridlines at even times, such as 8:00 AM, 9:00 AM, 10:00 AM, 11:00 AM etc. My data, however, occasionally falls in between these times, i.e., 8:05 AM, 9:17 Am, etc. When these points are plotted (correctly), an extra vertical gridline appears automatically at the correct data time. My problem is I don't want that data point gridline to appear. Is there any way I can opt not to get the extra line?? Thx Dave |
#4
|
|||
|
|||
Time on the X Axis Issue
Thanks once again Jon, that got it.
I still think time on the X-axis is a bear. Guess I have to look at more options when I get stuck - Lord knows there are enough of them BTW - you Excel MVP site looks superb. I obviously need to spend some time there Thx again - much appreciated Dave "Jon Peltier" wrote in message ... If you get an X axis tick for every data point, either the data is very regular, or you're still using a line chart. In the first step of the chart wizard, go all the way to the fifth icon down the list, not the third, and make an XY chart. You can get any formatting: with or without lines, with or without markers; the same as in a line chart. But the axis is a true value axis. Also, if Excel recognizes the times as times, it will plot them as such. Problem is, in a line chart, Excel only plots integer values, so all times for a given date are plotted at midnight. In an XY chart, the data is plotted according to value. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Dave" wrote in message ... Thank you Jon - That helps, but the X axis labels continue to match my actual data point times, rather than the even time increments I want. Can we do something about that? BTW, I've been using line charts for years, although I have to admit seldom on time X-axis data. Which has always driven me a bit nuts because of the way the scales want to be set. Whatever. Thx again. Dave "Jon Peltier" wrote in message ... 1. Use an XY chart, not a line chart. 2. Delete the gridlines. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Dave" wrote in message ... Posted this on Excel - no response. Guess I should have been here. I am trying to plot events on a time abscissa. I would like to have the major gridlines at even times, such as 8:00 AM, 9:00 AM, 10:00 AM, 11:00 AM etc. My data, however, occasionally falls in between these times, i.e., 8:05 AM, 9:17 Am, etc. When these points are plotted (correctly), an extra vertical gridline appears automatically at the correct data time. My problem is I don't want that data point gridline to appear. Is there any way I can opt not to get the extra line?? Thx Dave |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Graphing error using Time as X axis. | pete3589 | Worksheet Functions | 2 | December 16th, 2005 04:50 PM |
Fix time zone issue in outlook. | Joel | Calendar | 1 | October 28th, 2005 04:45 PM |
Outlook 2003 Terminal Server Time Zone issue | Robert Strom | Calendar | 2 | May 26th, 2004 10:50 PM |
Format Axis - Time | Kevin Stecyk | Charts and Charting | 2 | May 26th, 2004 04:43 PM |
Time and Date on X axis | DataMan | Charts and Charting | 12 | September 22nd, 2003 05:38 AM |