| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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  90 contain the changeE61 90 contain the percent changeNot 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 |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > > 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 90 contain the change> E61 90 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 > |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do i change the stack of colours chart to values not percent? | Nikky Noo | Microsoft Excel Charting | 1 | 23rd Mar 2009 11:23 AM |
| Change and refresh OLEObject showing Excel chart. | Chrisso | Microsoft Access Form Coding | 0 | 22nd Dec 2008 11:18 AM |
| Percent showing hundreds instead of actual percent number | =?Utf-8?B?SnVkeVQ=?= | Microsoft Access Reports | 1 | 27th Apr 2006 03:27 PM |
| Bart chart with lines showing % change between elements | =?Utf-8?B?VG9t?= | Microsoft Excel Charting | 1 | 31st Aug 2005 02:01 AM |
| Excel chart data labels showing % change instead of value? | =?Utf-8?B?TUZyaXR6?= | Microsoft Excel Charting | 1 | 20th Jul 2005 02:37 PM |
