Assignment -16 | Revenue Analysis and Visualization

Excepted timing : 10 minutes

| 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.