List Of How To Add Data Analysis In Excel References. Select “options” from the list that appears. Customize the results as needed.

Choose an analysis type (e.g. Web as you'll see, creating charts is very easy. Analyze data in excel will analyze your data, and return interesting visuals about it in a task pane.