![]() |
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? |
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