stock graph

[Debra VerSteeg]

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
at http://www.ExcelTip.com/
------------------------------------------------

 

[Jon Peltier]

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

 

[Debra Dalgleish]

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 VerSteeg]

Jon
You are wonderful, this worked great!
Thanks
Debra