InvestorsHub Logo
Followers 1
Posts 321
Boards Moderated 0
Alias Born 01/30/2002

Re: whitelake post# 771

Friday, 05/31/2002 2:16:14 AM

Friday, May 31, 2002 2:16:14 AM

Post# of 8728
Actually, you could do several things.

(BTW, I have a Dutch version of Excel 2000, so the names of options might be a bit off.)

1. Easiest is to right click on the upper axis (when the mouse hovers over the axis, you'll see the popup hint 'Category axis': then you do the right click). Select the option Format axis and open the tab Patterns. Select by Tick(?) labels(!) the option High, and click OK.

2. Almost as easy: Open the same dialog for the left axis (Value axis), open the tab Scale and check 'Category axis crosses? at:' and enter -110 (the lowest value in your graph). Click OK.

Regards,

Karel

Join InvestorsHub

Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.