Answered! Now, you want to use the knowledge of Microsoft Excel that you have gained in your office. Your manager has asked…

Now, you want to use the knowledge of Microsoft Excel that you have gained in your office. Your manager has asked you to create a report showing the variance between the actual and projected results. You realize that just looking at numbers does not give a clear picture. Therefore, you decide to use the powerful charting feature of Microsoft Excel.

Discuss the following in relation to charts:

Don't use plagiarized sources. Get Your Custom Essay on
Answered! Now, you want to use the knowledge of Microsoft Excel that you have gained in your office. Your manager has asked…
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE
Order Essay

What are the different ways of representing numerical data? What does each type of chart represent? Does each chart have a different or specific function? Explain with the help of examples.

In the meeting, your manager is impressed. He now asks you to change the data in worksheets for January, February, and March, as it has now been finalized. As the data changes, so do the chart and the report you created. Your manager questions you as to how this was achieved.

Discuss with reference to the following:

Linking worksheets and 3-dimensional (3D) formulas

Expert Answer

Various ways of representing data are:

  • Tables
  • List
  • Chats
  • Hierarchical diagram

Based on the type of data excel provides you different types of charts that suit your purpose.

Column Chart:

Column Chart displays the categories along the horizontal (category) axis and values along the vertical (value) axis. To create a column chart, arrange the data in columns or rows on the worksheet.

Line Chart

Line charts can show continuous data over time on an evenly scaled Axis. They are ideal for showing trends in data at equal intervals, such as months, quarters or years.

In a Line chart,

Category data is distributed evenly along the horizontal axis.

Value data is distributed evenly along the vertical axis.

To create a Line chart, arrange the data in columns or rows on the worksheet.

Pie Chart

Pie charts show the size of items in one data series, proportional to the sum of the items. The data points in a pie chart are shown as a percentage of the whole pie. To create a Pie Chart, arrange the data in one column or row on the worksheet.

Area Chart

Area Charts can be used to plot the change over time and draw attention to the total value across a trend. By showing the sum of the plotted values, an area chart also shows the relationship of parts to a whole. To create an Area Chart, arrange the data in columns or rows on the worksheet.

XY (Scatter) Chart

XY (Scatter) charts are typically used for showing and comparing numeric values, like scientific, statistical, and engineering data.

It combines x and y values into single data points and displays them in irregular intervals, or clusters. To create a Scatter chart, arrange the data in columns and rows on the worksheet.

Place the x values in one row or column, and then enter the corresponding y values in the adjacent rows or columns.

Consider using a Scatter chart when −

  • You want to change the scale of the horizontal axis.
  • You want to make that axis a logarithmic scale.
  • Values for horizontal axis are not evenly spaced.
  • There are many data points on the horizontal axis.
  • You want to adjust the independent axis scales of a scatter chart to reveal more information about data that includes pairs or grouped sets of values.
  • You want to show similarities between large sets of data instead of differences between data points.
  • You want to compare many data points regardless of the time.
    • The more data that you include in a scatter chart, the better the comparisons you can make.

Stock Chart

As the name implies, Stock charts can show fluctuations in stock prices. However, a Stock chart can also be used to show fluctuations in other data, such as daily rainfall or annual temperatures.

To create a Stock chart, arrange the data in columns or rows in a specific order on the worksheet. For example, to create a simple high-low-close Stock chart, arrange your data with High, Low, and Close entered as Column headings, in that order.

Surface Chart

A Surface chart is useful when you want to find the optimum combinations between two sets of data. As in a topographic map, colors and patterns indicate areas that are in the same range of values.

To create a Surface chart −

  • Ensure that both the categories and the data series are numeric values.
  • Arrange the data in columns or rows on the worksheet.

Radar Chart

Radar charts compare the aggregate values of several data series. To create a Radar chart, arrange the data in columns or rows on the worksheet.

Grand Paper Writers
Order NOW For A 10% Discount!
Pages (550 words)
Approximate price: -

Our Advantages

Plagiarism Free Papers

All papers are written by the best professional writers to ensure 100% originality. We always provide plagiarism reports whenever we deliver completed papers.

Free Revisions

All papers by Grand Paper Writers are completed and submitted on time. This timely delivery of papers gives you time to go through the paper before the official deadline.

Title-page

As an additional service, we will provide a title page that precedes the contents of your paper. Here, you will provide your personal details.

Bibliography

We also ensure that we provide an extra page for the references or bibliographies following referencing rules.

Originality & Security

At Grandpaperwriters.com, we guarantee students for the provision of security and original work. All your personal information is handled with confidentiality and is not shared with third parties. Additionally, we ensure that we provide original content with accompanying plagiarism reports to show originality.

24/7 Customer Support

Our customer support team is always available 24/7 to provide instant responses to any queries raised by students.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Grandpaperwriters.com has the best professional essay writers for quality services.

Pricing

Flexible Pricing

Here, a Grandpaperwriters.com, we do not compromise on the time of our clients. We always deliver all completed papers on or before the deadlines.

Communication

Admission Help & Client-Writer Contact

Grandpaperwriters.com provides an interactive portal where students can communicate directly to their writers.

Deadlines

Paper Submission

Here, a Grandpaperwriters.com, we do not compromise on the time of our clients. We always deliver all completed papers on or before the deadlines.

Reviews

Customer Feedback

Grandpaperwriters.com appreciates feedback from our clients to help us improve the delivery of essay writing services. As such, we are constantly changing our policies to ensure maximum customer and writer satisfaction.