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
|
|||
|
|||
Line chart for churn rates of many items over time
I have a set of data that tracks the number of changes to a file over
time. I want to show a line chart that I can use to visually locate a file with a low churn rate. "Low churn rate" could either mean "Has changed a lot in the past but hasn't changed in a while" or it could mean "has the lowest number of changes happening to it right now." The purpose of this is that we have a set of operations we want to perform on files, but only if they are fairly stable and either aren't getting changed often, or haven't changed in a while. My data is something like this: FileID,ChangedDate 1,8/23/2005 1,8/24/2005 1,8/25/2005 2,8/23/2005 3,8/23/2005 4,8/23/2005 4,8/24/2005 I'm having trouble wrapping my mind around how exactly I want this to look graphically. I definitely want the X axis to be time and I want one line in the chart per FileID, but I'm not sure about how to configure the Y axis to reach my goal of allowing me to visually pick out a "low churn" file. If I were to just have "Count of changeddate per fileid" as the Y axis, then all I get is a flat horizontal set of rows which just tells me a file has churned a certain amount, it doesn't tell me if it's churning less now than it was a month ago. If I make it a bar chart with the X axis of FileID and the Y axis ChangedDate, with the data portion being Sum of FileID, that *kind of* gets me what I want, because you can visually pick out the FileIDs that have a lot of bars next to them. The problem with this is that I expect to have hundreds if not thousands of FileIDs at some point, so I need something to help me visually pick those out... and perhaps a line chart isn't it, but it seems closer than anything else. Any pointers much appreciated, thanks. |
#3
|
|||
|
|||
Thanks Tushar, I'll give this a shot.
|
#4
|
|||
|
|||
In article .com,
says... Thanks Tushar, I'll give this a shot. You are welcome. If you get a chance, do post back how it works out for you. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to add animation to a chart - make lines appear | David Leonard | Powerpoint | 11 | June 2nd, 2005 12:33 AM |
double window envelope | tpdebronsky | Page Layout | 4 | May 17th, 2005 07:34 AM |
Three items, column and line chart | Carole O | Charts and Charting | 2 | April 11th, 2005 03:06 PM |
Draw line in a chart | Tushar Mehta | Charts and Charting | 5 | December 5th, 2003 06:19 PM |
Time performance Chart | Bull Splat | Charts and Charting | 6 | November 10th, 2003 02:16 PM |