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



  • 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

Postby RFF1aW50 » Sat, 09 Sep 2006 00:44:02 GMT

Brilliant! You are a lifesaver, thanks!

Similar Threads:

1.Bar Chart with bar data and another bar showing a range of data

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!!!!

2.max number of data ranges (bars) in a bar chart

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???

3.Customise error bars on individual bars in a bar chart 2007

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?

5.Graphics package, bar chart with several data series, organizing the data bars

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!


6. putting range bars (MIN AND MAX) on a bar chart of medians

7. How do Bar chart where Bar colour changes with different data Valu

8. Data labels overlay bar on bar chart

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 13 guest