stock graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Debra VerSteeg - 26 Aug 2003 21:26 GMT

I need help with the stock graph. I am making a graph that uses high,
low, and middle value as the stock chart does. But I need the value
axis to be on the bottom were the x axis is and the category axis to be
the Y axis. I want the final chart to have the high, low and middle
values displayed horizontally, rather the vertically. Is there a way to
which these axises? Thanks
for the help

------------------------------------------------
/

-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
-- Hundreds of free MS Excel tips, tricks and solutions at http://www.ExcelTip.com/
------------------------------------------------

Reply to this Message

Jon Peltier - 27 Aug 2003 01:41 GMT

Debra -

You can't switch these axes, but I have an example of how you can
construct such a chart on my web site:

http://www.geocities.com/jonpeltier/Excel/Charts/HorizontalHLC.html

Other Debra -

See, I told you someone would be interested in this one, eh?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> I need help with the stock graph. I am making a graph that uses high,
> low, and middle value as the stock chart does. But I need the value
[quoted text clipped - 10 lines]
> -- Hundreds of free MS Excel tips, tricks and solutions at http://www.ExcelTip.com/
> ------------------------------------------------

Reply to this Message

Debra Dalgleish - 27 Aug 2003 02:22 GMT

> See, I told you someone would be interested in this one, eh?

If only you could use your amazing clairvoyant powers to predict the
stock prices...

> Debra -
>
[quoted text clipped - 27 lines]
>> http://www.ExcelTip.com/
>> ------------------------------------------------

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message