Chart Question
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. |
Chart Question
On Nov 2, 7:39*pm, carl wrote:
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. Please take a look at:- http://www.pierrefondes.com/ - item 124. Could this be adapted to meeet your needs? |
Chart Question
On Nov 3, 1:12*pm, trip_to_tokyo wrote:
On Nov 2, 7:39*pm, carl wrote: 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. Please take a look at:- http://www.pierrefondes.com/ *- item 124. Could this be adapted to meeet your needs? Thank You. I think I can use this. Is there a way to have the chart update when the numbers change ? |
Chart Question
On Nov 4, 12:43*pm, carl wrote:
On Nov 3, 1:12*pm, trip_to_tokyo wrote: On Nov 2, 7:39*pm, carl wrote: 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. Please take a look at:- http://www.pierrefondes.com/ *- item 124. Could this be adapted to meeet your needs? 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 - 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 ? |
Chart Question
On Nov 4, 4:43*pm, carl wrote:
On Nov 3, 1:12*pm, trip_to_tokyo wrote: On Nov 2, 7:39*pm, carl wrote: 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. Please take a look at:- http://www.pierrefondes.com/ *- item 124. Could this be adapted to meeet your needs? 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 - If you change any of the underlying numbers that chart will update in real time. |
Chart Question
On Nov 4, 5:04*pm, carl wrote:
On Nov 4, 12:43*pm, carl wrote: On Nov 3, 1:12*pm, trip_to_tokyo wrote: On Nov 2, 7:39*pm, carl wrote: 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. Please take a look at:- http://www.pierrefondes.com/ *- item 124. Could this be adapted to meeet your needs? 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 - 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 ?- Hide quoted text - - Show quoted text - 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. |
All times are GMT +1. The time now is 10:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com