ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Thresholds (https://www.excelbanter.com/charts-charting-excel/208594-thresholds.html)

linksgeek

Thresholds
 
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?

ShaneDevenshire

Thresholds
 
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.

--
Thanks,
Shane Devenshire


"linksgeek" wrote:

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?



All times are GMT +1. The time now is 08:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com