Question

Why is it important to include chart and graph components in Excel documents? What are some of the pros and cons of using charts and graphics with Excel?

Answer 1

Importance of using charts and graphs in excel:

Charts & graphs helps to create visually interesting presentation of large data sets.

A raw data table may contain exactly the same information as a chart or graph, but it is more difficult for an audience to understand

Chart & graph function provides clearer picture of given data & creates impactful effects, which allow users to draw analytical findings easily by spotting trends and patterns rather than looking through large data sets.

Pros:

-          Charts & graphs helps in making precise and meaningful management presentation by simplifying & reducing complex data sets.

-          Easily & quickly grasp of given information.

-          Analyzing tends and patterns, which is not possible through viewing large data sets.

-          Charts and graphical presentation can help adding interest of audience or engaging the users or for more detailed or original analysis.

Cons:

-          Difficulty in formation or creation of relevant charts among wide available variety in order to prepare meaningful presentation of data.

-          There is always some limitation attached to how much data can be presented via charts or graphs so that information is clear and not confusing.

-          A disadvantage of using charts or graphs is that, due to its design, a chart or graph will likely not be as precise as the raw data or may not present the criticalness of information as may be derived from data tables.