Display Average value accross the graph range

[tasawer]

Hi,

in Excel, I have a bar graph that dislpays time taken for a certain event. This is updated daily.

I wish to display an average value line across the whole chart cutting through all bar-graphs

I can calculate the average value of these times in a field, but I do not know how to overlay this value.

Your help is appreciated.

 

[pgc01]

Hi tasawer
Welcome to the board

Jon Peltier explains here how to do it:

http://peltiertech.com/Excel/Charts/AddLine.html