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



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

Glen Millar


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
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.


Glen Millar
Microsoft PPT MVP


Echo S

Glen Millar said:
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>

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