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


G

Guest

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

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
 
E

Echo S

Glen Millar said:
Hope that makes sense. This was for version 2003.
Click to expand...
Works that way in all versions, Glen. Well, all versions since at least 97,
anyway. <g>
 
You must log in or register to reply here.

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

Similar Threads

Bar Chart Formatting Data Labels 0
How do I add an icon that shows how much left in a powerpoint? 2
How do I add a data series in a combination chart in PPT 2003? 2
how do I change the color of the bars in a Bar Chart? 2
How do I add different music to different slides in powerpoint 1
two addins, same code, different functions 0
How do you add an Error bar in a line graph 1
how do i add a statistic counter 1

Top