Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
3 data stock graph with average
Hi,
I have a data table for a dept based on quality assessment scores: Name Min Max Avg Steve 2 5 3 Dave 10 20 11 I also know that the departmental average is (say) 8 I have the data presented using a stock graph to show each member of staff with a veritcal line showing the min to max and then a point in this line showing the persons average. What I want to do is overlay a straight horizontal line to represent the department average. Is this possible? Thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
3 data stock graph with average
This is certainly possible. A stock chart is really just a line chart under
the covers. Add an XY series as described in this link: http://peltiertech.com/Excel/Charts/AddLine.html "macroapa" wrote in message ... Hi, I have a data table for a dept based on quality assessment scores: Name Min Max Avg Steve 2 5 3 Dave 10 20 11 I also know that the departmental average is (say) 8 I have the data presented using a stock graph to show each member of staff with a veritcal line showing the min to max and then a point in this line showing the persons average. What I want to do is overlay a straight horizontal line to represent the department average. Is this possible? Thanks. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
3 data stock graph with average
This is certainly possible. A stock chart is really just a line chart under
the covers. Add an XY series as described in this link: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "macroapa" wrote in message ... Hi, I have a data table for a dept based on quality assessment scores: Name Min Max Avg Steve 2 5 3 Dave 10 20 11 I also know that the departmental average is (say) 8 I have the data presented using a stock graph to show each member of staff with a veritcal line showing the min to max and then a point in this line showing the persons average. What I want to do is overlay a straight horizontal line to represent the department average. Is this possible? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate weighted average of stock cost | Excel Worksheet Functions | |||
on bar graph, how to superimpose line of average values over bars | Charts and Charting in Excel | |||
Office 2003 Stock Action Add-In - Stock Handling Capacity/Numbers | Excel Worksheet Functions | |||
challenging "share stock" average prices | Excel Worksheet Functions | |||
2 Variable Graph - want average line??? | Charts and Charting in Excel |