I know how to set the error bars on a standard line graph. Unfortunately when
I set it the error bars appear the same at every plot. On the data I have the
points have varying error ranges. My question is, how can I set different
error bars for each individual point?
Hi,
Use the Custom /- values, which allows you to use values from cells.
See Jon's explanation of error bars.
peltiertech.com/Excel/ChartsHowTo/ErrorBars.html
Cheers
Andy
Jerry wrote:
gt; I know how to set the error bars on a standard line graph. Unfortunately when
gt; I set it the error bars appear the same at every plot. On the data I have the
gt; points have varying error ranges. My question is, how can I set different
gt; error bars for each individual point?
--
Andy Pope, Microsoft MVP - Excel
www.andypope.info
- Jan 12 Mon 2009 20:48
Individual Error Bars
close
全站熱搜
留言列表
發表留言