View Single Post
  #3   Report Post  
Tushar Mehta
 
Posts: n/a
Default

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.