Which of the following is not a valid chart type in Microsoft Excel?
Which of the following is not a valid chart type in Microsoft Excel?
(A) Line-Chart
(B) Pie-Chart
(C) Tree Graph
(D) Bar-Chart
In Excel, there is no chart type that is called “Tree Graph” or “Tree Diagram”. Although Excel does have a chart type called “Treemap,” which is used for presenting hierarchical data, “Tree Graph” is not a chart type in Excel.
Line chart: This type of chart is best for showing how the data is changing with time and for finding trends.
Pie chart: This type of chart is best for showing how each part of a whole compares as a percentage.
Bar chart: This type of chart is best for comparing different categories of data, using horizontal bars.