Plotting a single data point on a histogram chart

Question

I have created a histogram in excel and then created a graph from the results.  I now want to plot a single data point onto the graph to show the average, but every time I do this it is plotting the value on the y axis and ruining the graph that I originally created.

For example:  I have the values:

Bin Range	No of Properties
20	8
40	17
60	6

I have created a graph from this so the bin ranges are on the x axis and the no of properties are on the y axis.  I want to add another data series to show the average no of properties is 30 but if I add a new data series, then it plots it against the no of properties which means that the y axis suddenly increases and the original line graph created is pushed to the bottom of the graph as the axis has increased in size.  Instead I want to show a single data point on the x axis (where it crosses 0 on the y axis) to show this average.

Can anyone help?

Answer 1

Have you though of adding a Shape (say a triangle) from Inset | Shapes. You can position this exactly wehre you need. If you have lots of charts this might be too labour intensive but OK for a few. best wishes

---

people.stfx.ca/bliengme