Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel should have an open/close high/low chart for stock market u.
We're trying to develop a chart that would compare the price of grain traded
on the Chicago Board of Trade (cbot) to our average price reported in Iowa. It would require four data points for the cbot info - open/close & high/low - and one for the comparator, in this case the average price for our state. We would like to see this chart added to Excel, but even if it is not added, we welcome any suggestions or recommendations of charting software compatible with Excel. Oh, by the way, we're using Excel 2003. |
#2
|
|||
|
|||
Hi,
Jon Peltier has a few stock (ochl) chart variations, check his site index as well. http://peltiertech.com/Excel/Charts/StockChartPlus.html Cheers Andy Harold Hommes wrote: We're trying to develop a chart that would compare the price of grain traded on the Chicago Board of Trade (cbot) to our average price reported in Iowa. It would require four data points for the cbot info - open/close & high/low - and one for the comparator, in this case the average price for our state. We would like to see this chart added to Excel, but even if it is not added, we welcome any suggestions or recommendations of charting software compatible with Excel. Oh, by the way, we're using Excel 2003. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Just use the chart that plots volume, open, high, low, close data and
put your own price in the volume column. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , "=? Utf-8?B?SGFyb2xkIEhvbW1lcw==?=" <Harold says... We're trying to develop a chart that would compare the price of grain traded on the Chicago Board of Trade (cbot) to our average price reported in Iowa. It would require four data points for the cbot info - open/close & high/low - and one for the comparator, in this case the average price for our state. We would like to see this chart added to Excel, but even if it is not added, we welcome any suggestions or recommendations of charting software compatible with Excel. Oh, by the way, we're using Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a marker on an Excel bar chart? | Charts and Charting in Excel | |||
Lines not visible in an Excel line chart | Charts and Charting in Excel | |||
How do I set up a Levy-Jennings chart in Excel? | Charts and Charting in Excel | |||
excel chart size using inside positioning | Charts and Charting in Excel | |||
How do I break the value (Y) axis in an Excel chart ?? | Charts and Charting in Excel |