PVR101
asked on
excel data graph plot
Hi,
is there anyway I can plot recorded data in format 30/45 etc attached is sample data that wish to be able to plot for trend analysis. The readings are from an ampmeter on pumps and generally fluctuates from a hi/lo reading hence 30/45 format on most pumps. Is there anyway to plot say a median of this for each pump or both readings in graphical form (line plot say).
many thanks
ampmeter-data.xls
is there anyway I can plot recorded data in format 30/45 etc attached is sample data that wish to be able to plot for trend analysis. The readings are from an ampmeter on pumps and generally fluctuates from a hi/lo reading hence 30/45 format on most pumps. Is there anyway to plot say a median of this for each pump or both readings in graphical form (line plot say).
many thanks
ampmeter-data.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi PVR101,
I'm glad the chart works for you, but I'm afraid the new request is beyond the scope of this question. Hi-Low lines or shades backgrounds involves complex additions to data structure and the chart design and was never included in the initial spec. I feel that this would warrant a new or follow-up question.
regards, teylyn
I'm glad the chart works for you, but I'm afraid the new request is beyond the scope of this question. Hi-Low lines or shades backgrounds involves complex additions to data structure and the chart design and was never included in the initial spec. I feel that this would warrant a new or follow-up question.
regards, teylyn
ASKER
no problem - understand and accepted will post new request. Thank You
ASKER
yes the modified chart and code works v well but wondering if possible to further modify so maybe able to either plot both hi-lo lines for each and maybe shade area or input value label for min-max pts for each line on plot so effectively seeing variance with the last data point labled? not sure if this is feasible or end up too confusing on graph but would be nice to achieve.
regards