i have three stock prices. say 20, 40, and 60. how do i get one column to
show the three numbers corresponding to the scale on the y axis? it needs to
be more of a floating bar, too. meaning it doesnt start on the x axis, rather
the bar only goes from 20-60. thanks!

If you rearrange your numbers a little to be high price, low price, then
closing:
Try just using the stock charts.

If that won't work, see:
http://www.peltiertech.com/Excel/Cha...mat.html#Float
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"bfont" wrote:

i have three stock prices. say 20, 40, and 60. how do i get one column to
show the three numbers corresponding to the scale on the y axis? it needs to
be more of a floating bar, too. meaning it doesnt start on the x axis, rather
the bar only goes from 20-60. thanks!