Help with a bar chart?

J

JV

I have this bar chart and I have number totals for each month. Now...I need
a average of all months together and show it as a number, but NOT have it
show on the bar chart as a bar. Is this possible?
 
B

Bernard Liengme

You could add a horizontal line; see
http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts/straight_lines/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_charts_horizontal_line.htm
OR you could compute the average in a cell, click the text, in Formula bar
type = then point at cell with average formula. This gives a text box with
the value; you can drag this around the chart to desired position.
Not sure what you want; you just specified what you didn't want.
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top