Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination Chart- 1 Column, 2 Lines | Charts and Charting in Excel | |||
MS Chart Line-Column ( 3 Lines 1 -column ) | Charts and Charting in Excel | |||
How do I change column into lines on a Line-Column chart? | Charts and Charting in Excel | |||
How to create chart with 1 column and 3 lines | Charts and Charting in Excel | |||
On a combination chart how do i get 2 lines and 1 column? | Charts and Charting in Excel |