33.9k views
4 votes
Upload an Excel Sheet with a table having 4 columns and 10 rows filled with data. Using this table create the following 1 - Recommended Chart using only 3 columns 2 - Pie chart - using 4 columns 3- Line chart - Using 4 columns - change the legend to Sales 4- Add data label to the recommended chart in Question 1

User Imskull
by
7.4k points

1 Answer

7 votes

I apologize for the inconvenience. Since I am unable to upload files directly, I will guide you on how to create the charts and add data labels in Excel using the data you provided.

Assuming your data is arranged in columns A, B, C, and D, with the first row being the headers, you can follow these steps to create the requested charts and add data labels:

1. Recommended Chart using only 3 columns:

- Select the data in columns A, B, and C (excluding the header row).

- Go to the "Insert" tab in Excel.

- Choose a chart type that suits your data, such as a column chart or line chart.

- Excel will automatically create the recommended chart using the selected data.

2. Pie Chart using 4 columns:

- Select the data in columns A, B, C, and D (excluding the header row).

- Go to the "Insert" tab in Excel.

- Choose the "Pie" chart type from the "Charts" section.

- Excel will create a pie chart using the selected data.

3. Line Chart using 4 columns - changing the legend to "Sales":

- Select the data in columns A, B, C, and D (excluding the header row).

- Go to the "Insert" tab in Excel.

- Choose the "Line" chart type from the "Charts" section.

- Excel will create a line chart using the selected data.

- Right-click on the chart and select "Select Data".

- In the "Legend Entries (Series)" section, click on the series you want to change the legend for (e.g., the default series names like "Series1").

- Click on the "Edit" button.

- In the "Series name" field, enter "Sales" or any other desired legend name.

- Click "OK" to apply the changes.

4. Adding data labels to the recommended chart from Question 1:

- Select the recommended chart you created using 3 columns (from Step 1).

- Go to the "Layout" tab in Excel.

- Click on the "Data Labels" button in the "Labels" section.

- Choose the desired data label option, such as "Data Callout" or "Data Table".

- Excel will add the selected data labels to the chart, displaying the values of each data point.

Please note that these instructions may vary slightly depending on the version of Excel you are using. Feel free to adjust the steps accordingly.

"Leran more about " Excel using the data you provided.

"SPJ11"

User Basir Alam
by
8.3k points