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.

On Nov 2, 7:39*pm, carl <cmieda...@msn.com> 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?

On Nov 3, 1:12*pm, trip_to_tokyo <i...@pierrefondes.com> wrote:
> On Nov 2, 7:39*pm, carl <cmieda...@msn.com> 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 ?

On Nov 4, 12:43*pm, carl <cmieda...@msn.com> wrote:
> On Nov 3, 1:12*pm, trip_to_tokyo <i...@pierrefondes.com> wrote:
>
>
>
>
>
> > On Nov 2, 7:39*pm, carl <cmieda...@msn.com> 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 ?

On Nov 4, 4:43*pm, carl <cmieda...@msn.com> wrote:
> On Nov 3, 1:12*pm, trip_to_tokyo <i...@pierrefondes.com> wrote:
>
>
>
>
>
> > On Nov 2, 7:39*pm, carl <cmieda...@msn.com> 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.

On Nov 4, 5:04*pm, carl <cmieda...@msn.com> wrote:
> On Nov 4, 12:43*pm, carl <cmieda...@msn.com> wrote:
>
>
>
>
>
> > On Nov 3, 1:12*pm, trip_to_tokyo <i...@pierrefondes.com> wrote:
>
> > > On Nov 2, 7:39*pm, carl <cmieda...@msn.com> 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 ?- Hidequoted 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 ?- Hidequoted 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.