| 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. |
| 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 | |||
Threaded Mode
