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

Discussion in 'Microsoft Powerpoint' started by Guest, Nov 4, 2004.

  1. Guest

    Guest Guest

    How can I add error bars to a graph in powerpoint that are of different
    values in the same data series?
     
    Guest, Nov 4, 2004
    #1
    1. Advertisements

  2. Guest

    Glen Millar Guest

    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
     
    Glen Millar, Nov 4, 2004
    #2
    1. Advertisements

  3. Guest

    Echo S Guest

    Works that way in all versions, Glen. Well, all versions since at least 97,
    anyway. <g>
     
    Echo S, Nov 4, 2004
    #3
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.