horizontal bar charts

[Jose Mourinho]

H

I have the following data, which is a range between two end-points for a number of cases

Case A: 50% to 75
B 25% 65
C 35% 85

and want to display this as a horizontal bar chart where the bar starts at (for A) at 50% and finishes at 75%, with the other cases plotted below as different Series (obviously the x-axis is 0-100%). I cannot get any of the Chart types to do this

Any ideas

Jose

 

[Debra Dalgleish]

Set up your data like this:

A B C D
1 Start Add End
2 A 50% =D2-B2 75%
3 B 25% 65%
4 C 35% 85%

Copy the formula in cell C2 down to the row 4
Select cells A1:C4
Click the Chart Wizard button
Select the Bar chart type, and the Stacked Bar subtype
Complete the steps in the Chart Wizard

Select the completed chart, and select the Start Series
Choose Format>Selected Data Series
Choose None for the Area and None for the border.
Click OK