Graphs

[Texas Aggie]

This is what i would like to do but i can't make it work.

my measure - verticle bar
top 10% - horizontal line on same chart
top 20% - horizontal line on same chart
median - horizontal line on same chart.

i can get my measure and two of the additional measures to chart like i want
but when i try to add the 3rd horizontal line it changes one of the other
lines to a verticle bar. is it only possible to chart two horizontal lines
on a bar chart?

thanks

 

[Texas Aggie]

......or can i add just a horizontal line at a set value?

 

[Debra Dalgleish]

Right-click on the series that was changed to a bar
Choose Chart Type
Select the Line chart type, and one of the subtypes
Click OK

Jon Peltier has instructions for adding horizontal lines to a chart:

http://www.peltiertech.com/Excel/Charts/ComboCharts.html#AddLine