On Sun, 29 Apr 2007, in microsoft.public.excel.charting,
" said:

Targets Height
1.75% 0
1.75% 21

1.00% 0
1.00% 21


Now it's a different chart type, with its own Y axis, but it still
shares the same X values as the horizontal bar, so select Source Data in
the Chart menu at the top of the screen, and change the X Values: range
in the new series to be the first column under "Targets" in the table I
had you write previously.


Jon Peltier has more advice on making combination Horizontal bar and
line charts he

http://peltiertech.com/Excel/Charts/BarLineCombo.html


I kind of got there, my chart has diagonal lines?

Yes, it sounds like you just need to get that X Values range for the
scatter graph series changed over from the range it started out sharing
with the Horizontal Bar range. The latter is a category range and will
never give you the numbers you need. Because each value is read as 1
more than the previous, the lines end up slanted. You need to get that
{1.75%,1.75%,blank,1.00%,1.00%} range in place so the lines can be
properly vertical (also so they can be at 1.75% and 1.0% like you want
them to be.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.