Benches Uncategorized

4

Individual error bars in charts

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

I can't figure out how to put individual errors bars in a bar chart. That is, a different amount of error on each bar. It can be done in Numbers by putting a range in the 'custom' option, but 'custom' is not selectable on my version of Keynote 09. I know i could just copy a Numbers bar chart and paste it into Keynote, but i'd prefer to do it directly in Keynote.

Anyone know how to do it?

4 replies

Sign in or join Beachball Help to reply.

  1. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    In the Chart Inspector, click on the Series tab. Then click on the triangle next to Advanced at the bottom. That will reveal tabs to set trendlines and error bars.

    Edit: OK, Just reread your post and I see that you're looking for a way to set conditional error bars that depend on each bar's value, correct? If so, I don't see any way to do that - the custom setting is not available.

    Message was edited by: Waveman

  2. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Yup - you just have to select a range of cells for the custom positive and negative values.
    (see <http://homepage.mac.com/jtangen/customerrorbars.png&gt;)

  3. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Yes, but that's in Numbers. What i want to know is can it done directly in Keynote 09?

  4. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Nope. You would need to select a range of cells in Keynote and because it doesn't use a full spreadsheet (nor should it as slideware), you can't select reference cells. No big deal as you can just copy/paste from Numbers (it will retain the error bars) and change the look of the chart. One easy way to do this is to copy and paste the style of the Keynote chart to the pasted Numbers chart.