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.

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

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 <[email protected]>, "=?
Utf-8?B?SGFyb2xkIEhvbW1lcw==?=" <Harold
[email protected]> 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.
>