Chart showing percent change

Any suggestions on how to do this?

I need to graph a chart that depicts "percent change" in 30 stocks.

B61:B90 contain the stock symbol
C61:C90 contain the current price
D61:D90 contain the change
E61:D90 contain the percent change

Not sure of the best way to present this.

Select B61:B90, hold CTRL and select E61:E90 (so both ranges are selected),
start the chart wizard, and create a column chart. Format to suit.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"jermsalerms" <jermsalerms.28436n_1148137802.3117@excelforum-nospam.com>
wrote in message
news:jermsalerms.28436n_1148137802.3117@excelforum-nospam.com...
>
> Any suggestions on how to do this?
>
> I need to graph a chart that depicts "percent change" in 30 stocks.
>
> B61:B90 contain the stock symbol
> C61:C90 contain the current price
> D61:D90 contain the change
> E61:D90 contain the percent change
>
> Not sure of the best way to present this.
>
>
> --
> jermsalerms
> ------------------------------------------------------------------------
> jermsalerms's Profile:
> http://www.excelforum.com/member.php...o&userid=30167
> View this thread: http://www.excelforum.com/showthread...hreadid=543965
>