Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create a Bullseye chart with value thresholds | Excel Discussion (Misc queries) | |||
Negative Thresholds in SumProduct | Excel Discussion (Misc queries) |