Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing an axis to show time with hour intervals
I am trying to create a chart from a spreadsheet of data that has 3 years and
all 12 months. Each month has different days and different times where data was pulled. What I want to do is create a chart with all the months in the data and have the axis showing time intervals of an hour each starting from 12:00am-12:00am with the hours in between 12:00am, 1:00am, etc). Can anyone help me? I have tried using the scale under the format axis tab but can't figure out how to show time in intervals. Thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing an axis to show time with hour intervals
If your combined date and time is in A2, use =MOD(A2,1) to get just the
time, and use that as the X-axis series for your chart. -- David Biddulph "hollis78" wrote in message ... I am trying to create a chart from a spreadsheet of data that has 3 years and all 12 months. Each month has different days and different times where data was pulled. What I want to do is create a chart with all the months in the data and have the axis showing time intervals of an hour each starting from 12:00am-12:00am with the hours in between 12:00am, 1:00am, etc). Can anyone help me? I have tried using the scale under the format axis tab but can't figure out how to show time in intervals. Thanks. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing an axis to show time with hour intervals
I have 1470 lines of data with the Date and time on different cells. It looks
like this: A1: Fri Feb 13, 2004 A:2 5:00 PM it goes all the way down to A:1470. I have tried to separate the time from the date by making two columns (A: date B:time) but that doesn't work either. "David Biddulph" wrote: If your combined date and time is in A2, use =MOD(A2,1) to get just the time, and use that as the X-axis series for your chart. -- David Biddulph "hollis78" wrote in message ... I am trying to create a chart from a spreadsheet of data that has 3 years and all 12 months. Each month has different days and different times where data was pulled. What I want to do is create a chart with all the months in the data and have the axis showing time intervals of an hour each starting from 12:00am-12:00am with the hours in between 12:00am, 1:00am, etc). Can anyone help me? I have tried using the scale under the format axis tab but can't figure out how to show time in intervals. Thanks. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing an axis to show time with hour intervals
So, what do you want your x-axis to look like? Dates and times or
just times? If just times, then if you have multiple readings on different dates but at the same time, you expect to have all those values plotted one above the other corresponding to that time on the x-axis. Correct? On Mon, 6 Oct 2008 10:44:13 -0700, hollis78 wrote: I have 1470 lines of data with the Date and time on different cells. It looks like this: A1: Fri Feb 13, 2004 A:2 5:00 PM it goes all the way down to A:1470. I have tried to separate the time from the date by making two columns (A: date B:time) but that doesn't work either. "David Biddulph" wrote: If your combined date and time is in A2, use =MOD(A2,1) to get just the time, and use that as the X-axis series for your chart. -- David Biddulph "hollis78" wrote in message ... I am trying to create a chart from a spreadsheet of data that has 3 years and all 12 months. Each month has different days and different times where data was pulled. What I want to do is create a chart with all the months in the data and have the axis showing time intervals of an hour each starting from 12:00am-12:00am with the hours in between 12:00am, 1:00am, etc). Can anyone help me? I have tried using the scale under the format axis tab but can't figure out how to show time in intervals. Thanks. Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"h:mm" format, but 12-hour time, not 24-hour time? | Excel Discussion (Misc queries) | |||
Changing decimal time into 24 hour time and reverse | Excel Discussion (Misc queries) | |||
I want my X axis to have 5-10 minute intervals | Charts and Charting in Excel | |||
X-axis should read 20,000 years to 0 in intervals of 5,000 | Charts and Charting in Excel | |||
Setting x axis scale to time with variable intervals | Charts and Charting in Excel |