Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating Average Line on chart
I am making creating a bar graph that will graph 7 plants numbers based on a period. I have excel to where i enter the period # in cell a1 and then below it, it will pull the information for the period for each plant. I'm trying to place a line in the graph that will show the average performance of all of the plants for that period based on a cell that calculates up the average. Is there any way to set this up? I have tryed a few things with it but it always brings the average as another bar or just a dot, not a line like i need -- flourboy ------------------------------------------------------------------------ flourboy's Profile: http://www.excelforum.com/member.php...o&userid=26219 View this thread: http://www.excelforum.com/showthread...hreadid=564878 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating Average Line on chart
http://peltiertech.com/Excel/Charts/AddLine.html
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "flourboy" wrote in message ... I am making creating a bar graph that will graph 7 plants numbers based on a period. I have excel to where i enter the period # in cell a1 and then below it, it will pull the information for the period for each plant. I'm trying to place a line in the graph that will show the average performance of all of the plants for that period based on a cell that calculates up the average. Is there any way to set this up? I have tryed a few things with it but it always brings the average as another bar or just a dot, not a line like i need -- flourboy ------------------------------------------------------------------------ flourboy's Profile: http://www.excelforum.com/member.php...o&userid=26219 View this thread: http://www.excelforum.com/showthread...hreadid=564878 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average line across entire chart | Charts and Charting in Excel | |||
Excel chart draws line outside Y axis | Charts and Charting in Excel | |||
Change line in Chart | Charts and Charting in Excel | |||
Creating a line chart with two X-axes!! | Excel Discussion (Misc queries) | |||
Line chart - date line association gone mad! | Charts and Charting in Excel |