FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Selecting the right chart type Ask yourself how many variables do you want to show, how many data points you want to display and how you want to scale your axis. Line, bar and column charts represent change over time. Pyramids and pie charts display parts-of-a-whole.

Detailed explanation-2: -If you’re exploring charts in Excel and having a hard time figuring out which one is right for you, then you can try the Recommended Charts command on the Insert tab. Excel will analyze your data and make suggestions for you. Select the data you want to use for your chart. Click Insert > Recommended Charts.

Detailed explanation-3: -Line charts are among the most frequently used chart types. Use lines when you have a continuous data set. These are best suited for trend-based visualizations of data over a period of time, when the number of data points is very high (more than 20).

Detailed explanation-4: -Line Chart: The line chart is one of the most frequently used chart types, typically used to show trends over a period of time. If you need to chart changes over time, consider using a line chart.