|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|
Time is not correct on x-axis
In XL 2103, I copy data from a webpage and paste into a worksheet. One of the fields has time as, for example, 07/13/2015 19:00:01. I have a formula in another column - (VLOOKUP(HOUR(V18),How!P$3:Q$27,2,FALSE) to return the time as 19, 20,21, and use the lookup table to get 7pm, 8pm, etc. In the formula V is the column with the time, and P3:Q27 is the following table..
This returns the correct hour as 7am, 3am, etc. In the cells it works fine. but on the x-axis it shows up at 1,2,3,4 etc. I have to click on the a-axis and re-select the data (7am, 8am, etc.) in order for it to show up as hour/am/pm on the graph.
In summary, the x-axis currently reads 1,2,3, etc. and i want 7pm, 8pm, etc.., which i get only after click on the x-axis and re-selecting the data.
What must I do? Is there a better way to get the time from the time column (07/13/2015 19:00:01 for example)?
|Thread||Thread Starter||Forum||Replies||Last Post|
|Overlapping time (X) axis labels with auto axis options||Paul Kraemer||Charts and Charting in Excel||1||February 8th 09 04:44 AM|
|Subtract hours from a time and get the correct time||casey||Excel Worksheet Functions||1||June 22nd 08 08:41 PM|
|xy-scatter-labels disappear when x-axis is changed into time-axis (XL07)||Holger Gerths||Charts and Charting in Excel||8||June 5th 08 04:25 PM|
|TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS||vijaicbe||Charts and Charting in Excel||4||November 9th 06 11:16 AM|
|x axis not showing correct values||Micayla Bergen||Charts and Charting in Excel||1||August 28th 05 01:57 AM|