ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Dispatch column to 3 chart lines (https://www.excelbanter.com/charts-charting-excel/228913-dispatch-column-3-chart-lines.html)

rduke15

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