overlapping error bars

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have created a chart which compares 2 sets of data on a line graph.
I would like to add error bars to the chart, but when I do this they
overlap making the chart uninterpretable.

Ideally I'd like to move one line forwards or backwards along the x
axis a small amount bringing the error bars out of phase with each
other. I have not found a way of doing this using excel - does anyone
know how to do this or any other way around this problem?

thanks,
Graham

.

Relevant Pages

  • Re: Bug! Error Bars Inherited from Another Workbook - Any Fix?
    ... If & when I get a chance I'll forward it to the Excel guys. ... First, create a data workbook. ... column 2 for the error bars. ... Next, a chart workbook. ...
    (microsoft.public.excel.charting)
  • Re: difficult graph ?
    ... Start the chart wizard and make an XY Scatter chart (a ... Format the points to be invisible ... error bars with distinctive colors, and no cross at the end. ... Don't type the curly braces. ...
    (microsoft.public.excel.programming)
  • Re: difficult graph ?
    ... Start the chart wizard and make an XY Scatter chart (a ... Format the points to be invisible ... error bars with distinctive colors, and no cross at the end. ... Don't type the curly braces. ...
    (microsoft.public.excel.charting)
  • Re: Bug! Error Bars Inherited from Another Workbook - Any Fix?
    ... One effective way would be to extract the data from the chart back into ... Jon Peltier, Microsoft Excel MVP ... First, create a data workbook. ... column 2 for the error bars. ...
    (microsoft.public.excel.charting)
  • Re: difficult graph ?
    ... Do you mean you don't see the option to add X Error Bars? ... Change the chart to an XY Scatter chart, ... > Jon Peltier, Microsoft Excel MVP ... > Peltier Technical Services ...
    (microsoft.public.excel.charting)