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

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.

4.BAR CHARTS-DISPLAYING A WHOLE BAR AND A STACKED BAR ON THE SAME GRAPH

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!

jpdphd/

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