Add mean and Standard Deviation to Histogram

A

Anuta

Is there any way to add vertical lines of mean and Standard Deviation to a
Histogram?
 
P

Peter_atherton

-----Original Message-----
Is there any way to add vertical lines of mean and Standard Deviation to a
Histogram?
Anna

You can use Line_Column type of chart on the custom Chart
Tab. This will allow you to add either the mean of the std
dev. Show data as
23 39.5
34 39.5
45 39.5
56 39.5

where 39 is the average.

You will have to add the other line yourself using the
drawing toolbar.

Remember to select the whole chart including the Added
line and select Draw, Group on the drawing toolbar.

Regards
Peter
 
P

Peter Atherton

-----Original Message-----
Is there any way to add vertical lines of mean and Standard Deviation to a
Histogram?
Anuta

Create a Line-Column chart then right-click the columns in
the chart and select format data series. On the Y error
Tab you can choose to add a stddev line default set at 1
to the chart. If you choose the above and below it shows
the average as well.

I only just found this so ignore my last post.

Regards
Peter
 

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