View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Chart showing percent change

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