Start my chart at 12PM rather than 12AM

I was wondering if there were an elegant solution to your problem, but I can't think of one. Since no one has responded, I'll give you my thoughts.

I assume you want this to start on noon of day 1 and then end at 11 am of day 2. In order for Excel to 'sort' this properly, you should make sure you have a day combined with your time in your data source table. If you then have the 'Row Label' as the date/time data, then group it by Day and by Hour, it should give you the ordering you want. I encountered two 'gotchas' that may make this problematic:
1) the table and the chart now have the day and the hour shown, with the hours being subsets of each day
2) Excel formats the hours by adding AM and PM, so you lose the military time format you had. I could not find a way to format the row data, even when I change the Number Format.

Your solution should work Pauley.

Hi Andy,
they said it was a pivot chart, and that is where Excel seems to use its own formatting rules. If a standard chart meets carrolct's needs, then your solution should work. I just had a feeling a pivot chart was needed for some reason (e.g. multiple records from 1:00 to 1:59 that need to be grouped to 1:00). carrolct could create a pseudo-pivot chart to 'compress' the data by hour, and then use a standard chart.

Sure wish I knew why I could not change the row label format in the pivot table. I looked around the net, and it seems to focus on changing the value data's format. Maybe I'll post a question, but it is not a critical issue for me right now. I'm sure Excel is just looking after my best interest...

You can do it in a pivot table/chart. I set the number format of the row items.

It would help if the OP could post example file.