Hello,
This thread is in link to another Posted thread titled "Chart and Statistics", the link to that thread is as follows: http://www.excelforum.com/excel-gene...tatistics.html
One of the members (squiggler47) had provided a great link to an example excel sheet that is similar to what I needed. This sheet had three examples of charts that I need. However, I kept on getting an error that I can't seem to fix. When I scroll over to the first graph the following error pops up : " A formula in this worksheet contains one or more invalid references. Verify that your formuls contain a valid path, workbook, range name, and cell reference"
I tried fixing it but I keep on getting this error even after I save the file. I have data information on cost that is about 4000 records, and I would love to replace the data in Coloum B with mine to see how the distribution changes, but I am not sure if this is working because of the error.
Another question I have is, that when I add my data that is 2000 lines more than the example, Do I have to change anything else? Do I have to extend the number of lines in the Bins coloum unitil it get the "more" range?
Thanks and your help is greatly appreciated
SadafSh
Bookmarks