#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,344
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a Bullseye chart with value thresholds [email protected] Excel Discussion (Misc queries) 2 February 15th 07 04:28 PM
Negative Thresholds in SumProduct Everyday Joe Excel Discussion (Misc queries) 0 May 4th 05 05:14 PM


All times are GMT +1. The time now is 04:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"