Display Average value accross the graph range

tasawer

New Member
Joined
Nov 22, 2009
Messages
1
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.
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Watch MrExcel Video

Forum statistics

Threads
1,118,099
Messages
5,570,206
Members
412,308
Latest member
jt145
Top