ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   column chart question (https://www.excelbanter.com/charts-charting-excel/221481-column-chart-question.html)

bfont

column chart question
 
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!

Luke M

column chart question
 
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!



All times are GMT +1. The time now is 05:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com