How do I add error bars of different values within the same data .

[Guest]

How can I add error bars to a graph in powerpoint that are of different
values in the same data series?

 

[Glen Millar]

Hi,

You will need to do it in Excel. You will need to add the custom error bar
data amounts to your worksheet first. Then go to the bar graph:

Right click on a data series (in the Excel chart),
Select Format Data Series,
Y Error Bars tab,
Select the display type. We go for negative, so when you go to the next bit,
make sure you put the cell references in the negative Custom area, via...
Click in the Custom box (either + or - ) and navigate to the data you typed
in.
Then click OK and it should set to your custom points. Then you will have to
copy the graph and paste it into PowerPoint.

Hope that makes sense. This was for version 2003.

--
Regards,

Glen Millar
Microsoft PPT MVP
www.powerpointworkbench.com

Australia

 

[Echo S]

Hope that makes sense. This was for version 2003.

Works that way in all versions, Glen. Well, all versions since at least 97,
anyway. <g>