How can I auto generate graphs in excel?

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #109273

How can I auto generate graphs in excel?

qa-featured

 

Hello Conor,
 
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:
 
=OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A)-1)
 
Click Add.
 
Enter Temperature in the Names In Workbook text box.
 
Enter the following formula in the Refers To text box:
 
=OFFSET(Sheet1!$B$2,0,0,COUNTA(Sheet1!$B:$B)-1)
 
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:
 
=SERIES(,Sheet1!Date,Sheet1!Temperature,1)
 
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.

Login/Register to Answer

Related Questions