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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I add error bars to a graph in powerpoint that are of different
values in the same data series?
 
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
 

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

Highlight shape (Rectangle or Callout) with a value when mouse over 1
Graphs in Powerpoint 1
create a floating bar graph with min and max (price for example) 2
Charts do not display all of data in data table 3
Excel Error bars on barplot not in series in excel 2016 0
Bar chart values above max scale 3
Stacked graphs 1
PowerPoint 07 - Chart Area over slide 3

Back
Top