Chart Question

C

carl

I have a list of 200 stocks. The data table looks like this:

Stock Price Low High
AA 10.37 1.00 19.00
AAPL 396.51 350.00 450.00
ABX 49.32 36.00 65.00
AIG 23.42 15.00 34.00


Is there a way to create a chart that will visually describe where the
Price is Relative to the Low and High ?

Thank You In Advance.
 
T

trip_to_tokyo

I have a list of 200 stocks. The data table looks like this:

Stock   Price   Low     High
AA      10.37   1.00    19.00
AAPL    396.51  350.00  450.00
ABX     49.32   36.00   65.00
AIG     23.42   15.00   34.00

Is there a way to create a chart that will visually describe where the
Price is Relative to the Low and High ?

Thank You In Advance.
Click to expand...

Please take a look at:-

http://www.pierrefondes.com/

- item 124.

Could this be adapted to meeet your needs?
 
C

carl

Thank You. I think I can use this.

Is there a way to have the chart update when the numbers change ?- Hide quoted text -

- Show quoted text -
Click to expand...

Another question :)

My chart has the Stock on the x-axis and High Low on the y-axis.

Is there a way to reverse the axis - Stock on y and High Low on x ?
 
T

trip_to_tokyo

Thank You. I think I can use this.

Is there a way to have the chart update when the numbers change ?- Hide quoted text -

- Show quoted text -
Click to expand...


If you change any of the underlying numbers that chart will update in
real time.
 
T

trip_to_tokyo

Another question :)

My chart has the Stock on the x-axis and High Low on the y-axis.

Is there a way to reverse the axis - Stock on y and High Low on x ?- Hidequoted text -

- Show quoted text -
Click to expand...

EXCEL 2007

Right click your chart then click on:-

Select Data . . .

The Select Data Source window should open.

In this window click on:-

Switch Row/Column

- then click OK.

I am not sure, without seeing your Workbook, whether or not this will
work though.
 
Top