Hi. I need some help on getting the time to show correctly on the X axis of my charts.
I want to create a chart for each 15 minute increment in the day for 22 days.
Example -
Chart 1 (x axis):
Mon 5 2 12:00 AM , Tue 5 3 12:00 AM , ... Tue 5 24 12:00 AM
Chart 2 (x axis):
Mon 5 2 12:15 AM , Tue 5 3 12:15 AM , ... Tue 5 24 12:15 AM
The problem is that on the second chart, the dates show up correctly, but the increment is supposed to be 12:15, and it still shows 12:00.
I thought the chart was trying to round down, but I experimented on higher intervals, and it still did the same thing. I'm thinking it might be a scale issue? I'm not too sure, so if you got any ideas on what I'm doing wrong, please let me know!
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I want to create a chart for each 15 minute increment in the day for 22 days.
Example -
Chart 1 (x axis):
Mon 5 2 12:00 AM , Tue 5 3 12:00 AM , ... Tue 5 24 12:00 AM
Chart 2 (x axis):
Mon 5 2 12:15 AM , Tue 5 3 12:15 AM , ... Tue 5 24 12:15 AM
The problem is that on the second chart, the dates show up correctly, but the increment is supposed to be 12:15, and it still shows 12:00.
I thought the chart was trying to round down, but I experimented on higher intervals, and it still did the same thing. I'm thinking it might be a scale issue? I'm not too sure, so if you got any ideas on what I'm doing wrong, please let me know!
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>