Website Home Page |

Excel Assignments List

| Froyo Technologies Public Resources

|-------------|-----------|-----------|-----------|

| Product     | Sales Jan | Sales Feb | Sales Mar |

|-------------|-----------|-----------|-----------|

| Product A   | 1000      | 1200      | 800       |

| Product B   | 1500      | 900       | 1100      |

| Product C   | 800       | 700       | 600       |

 
Task :

1. Create a clustered column chart to compare sales of Product A, Product B, and Product C for each month.
2. Add data labels to the columns in the chart to display exact values.
3. Create a line chart to show the trend of sales for Product A over the three months.
4. Format the chart title, axes labels, and legend to enhance readability.
5. Insert a pie chart to represent the percentage distribution of sales across all three products in March.

To perform the tasks outlined in Assignment  using Excel, follow these step-by-step instructions:

 

 

1. Create a clustered column chart to compare sales

Steps:

• Select the data range that includes Product names and their respective sales for each month (Jan, Feb, Mar).
• Go to the "Insert" tab in Excel.
• Click on "Column Chart" under the "Charts" group, then select "Clustered Column."
• Excel will generate a clustered column chart comparing sales of Product A, Product B, and Product C for each month.

2. Add data labels to the columns in the chart

Steps:

• Click on the clustered column chart to select it.
• Go to the "Chart Elements" button (plus sign icon) that appears when you click the chart.
• Check the box next to "Data Labels."
• Excel will add data labels to each column, displaying the exact values of sales.

3. Create a line chart to show the trend of sales for Product A

Steps:

• Select the data for Product A's sales over the three months (Jan, Feb, Mar).
• Go to the "Insert" tab.
• Click on "Line Chart" under the "Charts" group, then select "Line with Markers."
• Excel will create a line chart showing the trend of sales for Product A over the three months.

4. Format the chart title, axes labels, and legend

Steps:

• Click on the chart to select it.
• Navigate to the "Chart Tools" section in the Excel ribbon.
• Use the "Chart Title," "Axis Titles," and "Legend" options under the "Chart Tools" to format them as needed.
• Adjust font sizes, styles, and colors for readability.

5. Insert a pie chart to represent the percentage distribution of sales

Steps:

• Calculate the total sales for all three products in March.
• Create a new table or range that includes Product names and their sales for March.
• Select the data range.
• Go to the "Insert" tab.
• Click on "Pie Chart" under the "Charts" group, then select a suitable pie chart style.
• Excel will insert a pie chart representing the percentage distribution of sales across all three products in March.