asked on

Pivot tables response time website

Hi,

I urgently need to convert this xls into a graph.
It is the responsetime of a website from one month on a 5 minute basis. The graph should show date, time and response time on that time.
Don't know where I get it wrong but doesn't seem to make it work.

Thanks for your help!
J.
responsetimes.xls

Glenn Ray

I suggest inserting a new column and combining the date and time values in that column as your new time (x) axis.

Additionally, after the chart is created, the x-axis will need to be changed to a text axis. It will default to a date axis and will only show points on each calendar date, not by the h:mm value.

Also note that you're plotting more than 6,000 points, this will take time to process each step. I recommend graphing a smaller set (maybe first thousand points) first, make all the formatting changes to the graph that you want, then extending the data range.

I've attached an example file with a couple of graphs. responsetimes.xls

janhoedt

ASKER

Thanks! But now I would like to see a line instead of the confusing graph.
It's a response time of a website, responsetimes are in milliseconds (not seconds as in your Excelsheet) and are taken from different locations. Actually 1 location would be sufficicent + a check every hour would be ok. Do you know how to extract this from the data without manually editing each line?

Note: do you know also a dummy-guide for pivot-tables?
Cheers,
J.

ASKER CERTIFIED SOLUTION

Glenn Ray

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

janhoedt

ASKER

Great, thanks!