LinkBack URL
About LinkBacks
Hi,
I need help to create a graph that gives the no of connections on system 1 and system 2 for the given time frame. Please assist.
Hi,
I need help to create a graph that gives the no of connections on system 1 and system 2 for the given time frame. Please assist.
Last edited by rakesh2806; 05-18-2012 at 05:00 PM.
I think a pivot table in which you can group the time by hours is what you are looking for. See attached. Is this what you want?
Edit: Oops, forgot a graph.
Last edited by ChemistB; 05-18-2012 at 02:51 PM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you for the reply. This is not what I am looking for. I am lloking for a graph with the first column, second column and the fourh column. Basically I want a graph that shows how many sessions were connected to System One and system1 for the time mentiond in the first column
I have modified the pivot table for 1st, 2nd and 4th columns.
Let me see if I understand:
x-axis: TIME (Column A)
Y-axis 1: Sessions for system 1; values in column D that match "System1" in Column B
y-axis 2: Sessions for system 2; values in column D that match "System2" in Column B
Do you want a bar graph or a line graph or what?
Because, when I went and tried to build that, I ended up with pretty much the the same thing as ChemistB, just with smaller increments in the x axis???
Looks like this:
bar graph for rakesh2806.xlsx
Thank you so much. That was what I wanted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks