How can I auto generate graphs in excel?

Asked By Connor vargas 0 points N/A Posted 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?

• Status: Open
• Question Views: 1047
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Zorian Crust 80 points N/A #109273

How can I auto generate graphs in excel?

 

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.

About Zorian Crust

Questions
0

Answers
377

Best Answers
138

• Vote Up 0 Vote Down

• Posted on - 01/21/2012
• Question Category: MS Excel