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"
wrote in message
...
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