Website Home Page |

Excel Assignments List

| Froyo Technologies Public Resources

| Month     | Revenue A | Revenue B | Revenue C |

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

| January   | 5000      | 6000      | 4000      |

| February  | 7000      | 4500      | 5500      |

| March     | 4000      | 3500      | 3000      |

 
Task :

1. Create a stacked column chart to show total revenue for Product A, B, and C for each month.
2. Create a secondary axis in the chart to represent Revenue C as a line.
3. Add trendlines to the line chart showing the trend of Revenue A over the three months.
4. Use a radar chart to compare the revenue performance of Product A, B, and C across all three months.
5. Insert a histogram to analyze the distribution of revenue values for Product A.

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

Steps to Perform:

1. Create a Stacked Column Chart for Total Revenue
   • Select the data range including Month, Revenue A, Revenue B, and Revenue C.
   • Insert a "Stacked Column" chart from the "Insert" tab in Excel.
   • This chart will visually display total revenue for each month, segmented by Product A, B, and C.
2. Add a Secondary Axis for Revenue C
   • After creating the stacked column chart, click on it to select.
   • Right-click on the Revenue C data series.
   • Choose "Format Data Series" and then select "Secondary Axis."
   • Excel will adjust the chart to include Revenue C as a line with its own axis.
3. Include Trendlines for Revenue A
   • Click on the line representing Revenue A on the chart.
   • Right-click and choose "Add Trendline."
   • Select a suitable trendline type (e.g., linear) to show the trend of Revenue A over the months.
4. Utilize a Radar Chart for Comparative Revenue Performance
   • Select the data range including Month, Revenue A, Revenue B, and Revenue C.
   • Insert a "Radar Chart" from the "Other Charts" option under the "Insert" tab.
   • Opt for a filled radar chart style to effectively compare the revenue performance across Product A, B, and C for all three months.
5. Insert a Histogram to Analyze Revenue Distribution
   • Choose the data range containing Revenue A values across the months.
   • Navigate to the "Insert" tab, select "Insert Statistic Chart," and choose "Histogram."
   • Excel will generate a histogram chart, providing insights into the distribution of Revenue A data.