## Bar Chart with bar data and another bar showing a range of dat

MS EXCEL

### Next

• 1. How can I create a Gauss chart in Excel
Can I produce a Bell (Gauss) curve in Excell?
• 2. Vertical error bars only
Hi I have several line and scatter graphs where I want to add vertical error bars ONLY. Every time I try to do this, horizontal error bars appear as well. Is there a way of only inputting vertical error bars? I don't want to have to delete the horizontal ones every time as this will take up time. Cheers
• 3. Secondary Axis Grid lines
Is there a way to show grid lines for a secondary y-axis?
• 4. Bar graph to line graph
I am trying to redo a chart by looking at a scanned image on excell. It's a line graph. The 4th options under standard graphs. But, then I went to Custom Types and the graph I need is the B&W Column but it turns my graph into a bar graph. I need it to stay as a Line graph. Does anyone know what I can do too change that? Thx, dmk
• 5. Displaying the mean in a bar chart
Hi all, I have a stacked bar chart showing test score distributions. I would like to be able to plot the mean score on the bar. A simple dot or square would do. Anyone know how to do this? thanks! nathan

### Re: Bar Chart with bar data and another bar showing a range of dat

```Brilliant! You are a lifesaver, thanks!

```

```I have to create a chart that has three columns that I would like to show as
two bars,the columns are one with a fixed amount and the other two with a
negative to positive range. Do you know how this could be done?

Ive included a sample of the data, the first numeric column would be the
first set of bars (2.5, 8.9, etc.) and the second two columns would be the
range set of bars (-5.3 to 10.3, etc.)

Sample 1	  2.5	-5.3	10.3
Sample 2	  8.9	-2.5	20.3
Sample 3	  3.8	-7.4	14.9
Sample 4	  0.0	-7.1	7.1

Any help would be greatly appreciated! Thanks!!!!

```

```I am trying to create a simple bar graph with 23 different data ranges, there
is all the room in the world for 23 bars in a single graph, yet when I start
selecting the data ranges (or labels for that fact) it gets to about 17 of
them, and then erases everything I have selected and starts over. Ending up
with a graph that only contains the last 4 or 5 data ranges?????  I have also
search every help and internet and see addressing this???
```

```I posted this question a couple of days ago but it there seems to be an issue
with the MS notification system and I can't access the answer that someone
posted for me.

I want to allocate individual values for error bars in a bar chart, I'm
using Excel 2007. There is a customise option but the values you select apply
to all bars on the chart. As the bars in my charts are a mean value in
themselves, I want to show the error applicable to that bar.
```

```I'm trying to create a bar chart from 3 different data columns.  What
I'm looking to do is use the 1st column as one whole bar, but to put
columns 2 and 3 into one stacked bar.  Is there any way I can do this
on the same chart?
```

```On Oct 16, 2:46 pm, cruiser < XXXX@XXXXX.COM > wrote:
> Conducted a survey for a graduate study project, user ranking of
> several items. Users were asked to rank the same list as 1st
> important, second, etc. Created the bar chart, three series, not a
> problem. Professor wishes to see the bars for each series staggered
> highest to lowest, left to right, for all three sereis. Unfortunately,
> format data series>series order moves the data column IN ALL THREE
> series simultaniously. is there any way to create a single histogram
> of all three data sereis, maintaining the color key, and order the
> data columns for each sereis independently?

I don't really see the value in presenting the data this way (aside
from appeasing your professor). But, if you must...

You could get the data ordered in the way you (or the prof) wants, in
the spread sheet itself. Plot it, initially ignoring the colors. Then,
color each bar separately. To select an individual bar, select the
series and then press the right arrow key. Double click it and select
the color. All very tedious, but if it gets you an A, it might be
worth it!

jpdphd/

```