N/APosted on - 01/21/2012
It is necessary that I create graphs for the type and number of issues discovered during a test. I intend to use MS excel to auto generate the graphs. Is it possible to auto generate the graphs in excel? How can I go about auto generating the graphs in excel?
How can I auto generate graphs in excel?
I can surely help you with this because I am expert in MS Excel. Please follow the steps below:
Go to Insert | Name| Define.
Enter Date in the Names In Workbook text box.
Enter the following formula in the Refers to text box:
Enter Temperature in the Names In Workbook text box.
Enter the following formula in the Refers To text box:
Click Add and then OK.
Click on the chart, and then on the data series.
Change the formula in the formula bar to the following:
The chart will update automatically each day with a new temperature. Be sure you don't use Columns A and B for any other data; otherwise, COUNTA will return an incorrectvalue.