Access this solution immediately by signing up as a member of excelanswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.
Question
How to add "whiskers" to an Excel graph
I am trying to produce a graph in Excel that shows the mean of a dataset theough time with "whiskers". I don't know the proper name, for thise feature, but that what's we alsways called them when creating QC charts inthe manufacturing plant where I used to work. The ide is to plot the average with another small line (or whicker) above and below the datapoint representing the upper and lower range, or maybe one or two standard deviations from the mean. The resulting chart looks like a line banded on top and bottom by "whiskers" that represent how "wide" the distribution of the data was.
I have no problem calculating and supplying to Excel all the necessary inputs for each variable (mean, upper and lower whiskers), but don;t know how to format the graph so that it looks like this.
Any ideas?
Solution
About this Solution
Sign up Now to View This Solution- Zone
- general
- Tags
- Participating Experts
- 1
- Solution Grade
- A
Replies
Log In
Stay Connected
Top Experts
-
mlmcc
8,800
0 points yesterday
Profile -
rowanscott
2,200
0 points yesterday
Profile -
jimpen
2,000
0 points yesterday
Profile -
imnorie
2,000
0 points yesterday
Profile -
harfang
1,800
0 points yesterday
Profile -
kgreene
1,470
0 points yesterday
Profile -
Netminder
1,000
0 points yesterday
Profile -
GRayL
1,000
0 points yesterday
Profile -
eeshahidt
868
0 points yesterday
Profile -
patrickab
668
0 points yesterday
Profile -
tilsant
664
0 points yesterday
Profile -
redrumkev
400
0 points yesterday
Profile -
dave4dl
400
0 points yesterday
Profile -
byundt
200
0 points yesterday
Profile -
CORBETTMJ
200
0 points yesterday
Profile -
pari123
200
0 points yesterday
Profile -
tagit
200
0 points yesterday
Profile -
broomee9
200
0 points yesterday
Profile -
Dave96
200
0 points yesterday
Profile
Posted on 2005-12-18 at 13:05:34ID: 27202450
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.