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 |
#1
|
|||
|
|||
Date and Time on X-Axis, Measurement on Y?
I have collected performance monitor data in .csv format.
I can't seem to get any chart to display the date AND time at the bottom and the percent utilization as the line (using a line graph). Time series does not include minutes/seconds, but I want to show how utilization varies across a day or so. Best I can get is utilization as the line and just the row number on the x-axis. Is my goal possible? Thanks for any info. Dave K. |
#2
|
|||
|
|||
Dave -
In a line chart, you can only get resolution as fine as the day. Excel stores date-time data as a whole number for the day (the number of days since January 1, 1900) and a fraction for the portion of the day that's elapsed since midnight. Line charts use integers for the X axis, so all points for a given day are plotted at midnight at the start of the day. If you use an XY Scatter chart, you will be able to resolve times during the day. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ DaveK wrote: I have collected performance monitor data in .csv format. I can't seem to get any chart to display the date AND time at the bottom and the percent utilization as the line (using a line graph). Time series does not include minutes/seconds, but I want to show how utilization varies across a day or so. Best I can get is utilization as the line and just the row number on the x-axis. Is my goal possible? Thanks for any info. Dave K. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |
Calculating (Date and Time) differences | Madcap | Worksheet Functions | 0 | April 27th, 2004 08:56 AM |
Subtracting Time Zone for Universal Time and Date | Pal | Worksheet Functions | 1 | February 2nd, 2004 05:04 AM |
Does date fall between two ranges? | MR | Worksheet Functions | 4 | January 14th, 2004 04:08 PM |
Time and Date on X axis | DataMan | Charts and Charting | 12 | September 22nd, 2003 05:38 AM |