Archive of Mr Excel Message Board
Check out Bill's new book on Charts and
Graphs for Microsoft Office Excel 2007
Back to Charting for Excel archive index
Back to archive home
Charts
Posted by Rob on March 23, 2001 6:46 PM
Is it possible to create a chart similar to those used by "CNBC financial tv station" when they display the stock price and volume for a stock over a certain period - the trading volume for the stock is displayed below the main chart which contains the stock price.
I would like to create a chart using the same style to illustrate a function at work. The average daily "Response Time" would be displayed in the top portion using either bar or line graph while the daily volume would be displayed underneith in the bottom portion.
My spreadsheet contains the date in column A and the day of the week in column B. In column C the average response time is displayed in hours and the total volume for that day is displayed in column D.
Re: Charts
Posted by Mark on March 26, 2001 5:58 AM
I'm not familar with the CNBC charts, but I think I have an idea what you're trying to accomplish (solution courtesy of John Walkenbach).
probably the first thing to do is to create two rows of data linked to the date and the daily volume and give the new data range a name, something like 'VolumeData'. Then create the graph of the response time data.
Next, hightlight the area of data represented by 'VolumeData' and copy. Next select the entire chart, hold down the shift key, and on the menu bar click Edit>Paste Picture. This will paste a picture of the VolumeData into the graph. Next, select the picture of the data, and in the formula bar type =VolumeData and hit Enter. This will link picture in the graph to the data in the VolumeData range. The format of the VolumeData range will be reflected in the VolumeData in the graph. You'll just have to play around with the formating to get it the way you want.
Sorry if this is a bit confusing, hope you can make some use of the info.
Mark
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.