Thickness of error bars

I want to combine a histogram with an xy graph, but the only possibilities are either to combine a bar-graph with a line graph or to combine an xy-graph with y-error bars.

Neither is very good for my purpose, but the latter is the least bad, and I try to improve by chosing the thickest possible line for the error bar. I wonder if it were possible to make those errorbars even broader - perhaps as broad as a histogram bar?

NSV

NSV -

You may get more assistance if you explain what the end result should look
like.

It is quite possible to combine a Column chart type (vertical bars usually
used for a histogram) with an XY (Scatter) chart type. An example is the
Better Histogram available at www.treeplan.com, where the XY (Scatter) is
used to label the horizontal axis.

- Mike
www.mikemiddleton.com

"nsv" <nsv.2a29cb_1151411702.4322@excelforum-nospam.com> wrote in message
news:nsv.2a29cb_1151411702.4322@excelforum-nospam.com...
>
> I want to combine a histogram with an xy graph, but the only
> possibilities are either to combine a bar-graph with a line graph or to
> combine an xy-graph with y-error bars.
>
> Neither is very good for my purpose, but the latter is the least bad,
> and I try to improve by chosing the thickest possible line for the
> error bar. I wonder if it were possible to make those errorbars even
> broader - perhaps as broad as a histogram bar?
>
> NSV
>
>
> --
> nsv
> ------------------------------------------------------------------------
> nsv's Profile:
> http://www.excelforum.com/member.php...o&userid=26500
> View this thread: http://www.excelforum.com/showthread...hreadid=555987
>

NSV -

Your attachment does not show up in the microsoft.public.excel.charting
newsgroup where I am reading your messages, and I would not usually open an
attachment, anyway.

An excellent source for information about combination charts is

http://www.peltiertech.com/Excel/Charts/index.html

- Mike
www.mikemiddleton.com

"nsv" <nsv.2a3tld_1151484606.9485@excelforum-nospam.com> wrote in message
news:nsv.2a3tld_1151484606.9485@excelforum-nospam.com...
>
> Thanks Mike, an add-in that someone had bothered to make was exactly
> what I had hoped for, I just didn't know where to find it, and I can't
> make such things myself.
> I couldn't see right away if it solves my problem, but I will download
> and then hopefully it works.
>
> I would like to attach a spreadsheet to illustrate the problem, but
> this is for some reason not possible, so I attach a picture in stead.
> The upper graph is a pure xy-type where I can choose an arbitrary
> number of points to get a smooth line, but the vertical histogram
> representation must be made with errorbars and they are too thin to
> give a good picture
> The bottom graph is a combined bar/line type where the linear
> normaldistribution curve gets very clumsy because of the low number of
> points it must interpolate.
>
>
> +-------------------------------------------------------------------+
> |Filename: Statsample.JPG |
> |Download: http://www.excelforum.com/attachment.php?postid=4949 |
> +-------------------------------------------------------------------+
>
> --
> nsv
> ------------------------------------------------------------------------
> nsv's Profile:
> http://www.excelforum.com/member.php...o&userid=26500
> View this thread: http://www.excelforum.com/showthread...hreadid=555987
>

I'm writing this in www.excelforum.com where the attachment appears perfectly, and I don't know how to reach you the other way.

The task is to illustrate the statistical result of a number of measurements. The standard way is to show the actual measured values as discreete bars and the estimated normal-distribution as an overlaid continuous line. All statistics programs do this routinely, but I would like to do it in Excel.

I understand perfectly the feeling about attachments. This attachment is a .jpg picture, and I suppose such files are pretty safe. Anyway it says a lot more than I can describe with words.

The Peltier pages are excellent, but I have not found a solution to this problem.

I'm afraid the combination chart is out of question because the task requires a large amount of x-values to smooth the line part of the graph, but the numbers of bars is usually low. The combination chart can not operate with different number of x's as the xy-chart can. A way to manipulate the width of the y-errorbars would be ideal, if it only were possible.

On Thu, 29 Jun 2006, in microsoft.public.excel.charting,
nsv <nsv.2a5kbo_1151565902.5446@excelforum-nospam.com> said:

>The task is to illustrate the statistical result of a number of
>measurements. The standard way is to show the actual measured values as
>discreete bars and the estimated normal-distribution as an overlaid
>continuous line. All statistics programs do this routinely, but I would
>like to do it in Excel.

>I'm afraid the combination chart is out of question because the task
>requires a large amount of x-values to smooth the line part of the
>graph, but the numbers of bars is usually low. The combination chart
>can not operate with different number of x's as the xy-chart can.

What you have to do is make it a combination, not of a column series and
a line series, but a column series and a scatter series.

This is perfectly feasible; if you've already got your line series set
up, click on it and select "Chart Type". That will let you turn just
that series into a scatter graph. Now you can put as many points on the
bell curve as you need to make it look smooth.

--
Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.