Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How do you add an Error bar in a line graph

34 views
Skip to first unread message

3Dcommunications

unread,
Aug 18, 2008, 9:38:00 AM8/18/08
to
I am doing a Line graph and I am looking to plot the mean scores, which I
know how to do, the question I have is along with the mean scores I want to
also plot the Min. & Max score above and below the mean score , Is their any
way to add error bars in a Line graph?
--
B. Morrow

Echo S

unread,
Aug 18, 2008, 1:48:47 PM8/18/08
to
Either use the hi/low stock chart, or do the chart in Excel. You can't add
individual error bars in PPT's charts.

To add standard deviation and that type of error bar, right-click the line,
choose Format Data Series, and check your options on the Y Error Bars tab.

If you need to specify the error for each data point, you must do that in
Excel. The process is the same, but you have an option on the Y Error Bar
under standard error -- click the icon at the end of the input box to
specify a range of cells on the datasheet. Use that to determine what values
to use for the error bars.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


"3Dcommunications" <3Dcommun...@discussions.microsoft.com> wrote in
message news:FF2668ED-F04F-4245...@microsoft.com...

0 new messages