Thresholds

L

linksgeek

I am plotting response times for commands and would like to plot multiple
thresholds for these commands for different scenarios. Can I artificially
add these thresholds to Pivot table data or charts?
 
S

ShaneDevenshire

Hi,

What you do is create an new column with all the same values.
You can put the threshold amounts into the raw data and add that range to
the pivot table as a second data field. You will probably need to change the
calculation for this field to Average. And you will probably need to adjust
the value such that the result meets your need. Move the data button into
the coloumn area. then they will be displayed on the pivot table is a
friendly fasion. Plot the chart as a line chart.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Threshold Line Across Chart 2
Shade a section under line graph in excel 0
How do I apply conditional formatting to axis labels? 1
Plotting Graph with dynamic table 3
Data points in chart incorrect 0
Non Linear Scatter plot, need to find y value 3
controlling outlook from access 2007 0
Assign a trendline or threshold 1

Top