Excel 2007 - Custom error bars ??

Hi Bruno!

Thanks for your quick response. I tried the option you pointed out, but
my version of excel 2007 (English, trial) keeps crashing at the point
where I am pressing the left mouse button to drag the databox around my
error column.
Would that maneuver work on your version, I wonder?

Mat



Bruno wrote:
> Under the error bars menu, you have to click 'more options', first tab,
> errordisplay, and then the fifth options.
>
> I have a full version, in dutch, so I don't know the exact names in english.
>
> "mc.linux" wrote:
>
>> Hi everyone!
>>
>> I am sorry if this is a repeat of a common question, but so far I only
>> found contradictory information on this:
>> For scientific charting I depent on the "add custom error bars" function
>> which was running well in excel 2003: you could easily indicate a
>> column in your data as x/y errors in a chart.
>> Now I am running the trial version of excel 2007 - and the function is
>> gone! Does anyone know if this feature is implemented meanwhile in excel
>> 2007 and how to use it?? Single values as general error bars are not
>> helpful for me and I am wondering what sense this reduced feature makes
>> at all.
>>
>> I would be grateful for advice, because otherwise excel 2007 is
>> absolutely useless for me.
>>
>> Mat
>>

... one other thing:

I noticed the fact that in my project, the data columns and the chart
are on different tabs. This may be the reason why my version crashed and
the other not. Under Excel 2003, the error bar>customize window keeps on
top while switching tabs, under Excel 2007 the window just disappears




Bruno wrote:
> Under the error bars menu, you have to click 'more options', first tab,
> errordisplay, and then the fifth options.
>
> I have a full version, in dutch, so I don't know the exact names in english.
>
> "mc.linux" wrote:
>
>> Hi everyone!
>>
>> I am sorry if this is a repeat of a common question, but so far I only
>> found contradictory information on this:
>> For scientific charting I depent on the "add custom error bars" function
>> which was running well in excel 2003: you could easily indicate a
>> column in your data as x/y errors in a chart.
>> Now I am running the trial version of excel 2007 - and the function is
>> gone! Does anyone know if this feature is implemented meanwhile in excel
>> 2007 and how to use it?? Single values as general error bars are not
>> helpful for me and I am wondering what sense this reduced feature makes
>> at all.
>>
>> I would be grateful for advice, because otherwise excel 2007 is
>> absolutely useless for me.
>>
>> Mat
>>

In my case (Excel 2007 with whatever patches MS distributed through
its Update system), the custom error bars option works OK (*) as long
as the chart is on the same sheet as the data. It also works OK if
the error bars are created while the chart is on the same sheet as the
data and then moved to its own sheet or to another worksheet.

However, if the chart is anywhere but on the same sheet as the data,
the error bars consistently revert to a fixed length.

(*) Works OK is meant to be taken with many grains of salt. Any
attempt to add a vertical error bar always adds a horizontal error
bar. The latter has to be subsequently deleted.

On Tue, 05 Aug 2008 20:41:46 +0200, "mc.linux" <m1stletter RemoveThis @gmail.com>
wrote:

... one other thing:

I noticed the fact that in my project, the data columns and the chart
are on different tabs. This may be the reason why my version crashed
and
the other not. Under Excel 2003, the error bar>customize window keeps
on
top while switching tabs, under Excel 2007 the window just disappears





Bruno wrote:
> Under the error bars menu, you have to click 'more options', first tab,
> errordisplay, and then the fifth options.
>
> I have a full version, in dutch, so I don't know the exact names in english.
>
> "mc.linux" wrote:
>
>> Hi everyone!
>>
>> I am sorry if this is a repeat of a common question, but so far I only
>> found contradictory information on this:
>> For scientific charting I depent on the "add custom error bars" function
>> which was running well in excel 2003: you could easily indicate a
>> column in your data as x/y errors in a chart.
>> Now I am running the trial version of excel 2007 - and the function is
>> gone! Does anyone know if this feature is implemented meanwhile in excel
>> 2007 and how to use it?? Single values as general error bars are not
>> helpful for me and I am wondering what sense this reduced feature makes
>> at all.
>>
>> I would be grateful for advice, because otherwise excel 2007 is
>> absolutely useless for me.
>>
>> Mat
>>

Regards,

Tushar Mehta
Microsoft MVP Excel 2000-2008
www.tushar-mehta.com
Tutorials and add-ins for Excel, PowerPoint, and other products