Individual error bars in charts

Question

Level 1

65 points

Individual error bars in charts

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?

MacBook Pro 17, Mac OS X (10.5.2)

Posted on Jan 9, 2009 5:08 AM

Reply

Answer 1

Waveman

Level 3

930 points

Jan 10, 2009 2:15 PM in response to Grant Abt1

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

Reply

Answer 2

Jan 11, 2009 10:55 PM in response to Waveman

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

Reply

Answer 3

Grant Abt1 Author

Level 1

65 points

Jan 12, 2009 11:21 AM in response to Jason Tangen

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

Reply

Answer 4

Jan 12, 2009 3:28 PM in response to Grant Abt1

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.

Reply