Automatic updating graphs excel
In this lecture, we will learn how to choose the best chart based on our data and situation.
Download the Excel workbook used in the video tutorial and try the lesson yourself.
A common task on Excel is to have a chart and we need to update the data displayed by adding more data, from different worksheets.
A radar chart, also known as a spider chart or a star chart because of its appearance, plots the values of each category along a separate axis that starts in the center of the chart and ends on the outer ring.
A surface chart shows a three-dimensional surface that connects a set of data points.
Excel provides a variety of useful predefined layouts and styles (or quick layouts and quick styles) that you can select from.
You can customize a layout or style of a chart further by manually changing the layout and style of the individual chart elements that are used in the chart.