![]() |
Dispatch column to 3 chart lines
I'm not even sure how to word my problem, so Google searches haven't
been successful so far. I have data like this IP packet loss date-time 83.137.80.57 0 2009-04-24 12:57:00 83.137.80.58 14 2009-04-24 12:58:03 83.137.80.60 12 2009-04-24 12:59:03 83.137.80.57 0 2009-04-24 13:57:01 83.137.80.58 13 2009-04-24 13:58:02 83.137.80.60 11 2009-04-24 13:59:02 I would like to make a chart with 3 lines, corresponding to the 3 IP addresses. So I need to define a data series for each IP, and specify the IP value as a condition in the range. Another problem I seem to have is that the X axis with the date-times, seems to only offer a resolution of 1 day. I have not been able to make it display all date points (what I would really like of course, would be 1 hour resolution). Is Excel not the right tool for this sort of thing, or did I just not use the right keywords in my helpfile/Google searches? Thanks for any help or pointers. RD |
All times are GMT +1. The time now is 08:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com