Forum Discussion
Visualizing Year-over-Year Sales Data with Comparison Chart in Excel
Hi Qaiser_j
While Excel doesn't natively offer a "Ribbon Chart" like Power BI, you can still create an effective comparison chart that meets your requirements with some creativity.
You can create a Stacked Column Chart to represent year-wise sales with products stacked within the columns, follow these steps:
Select your data range (including product names and year-wise sales).
Go to the Insert tab in Excel --> Charts group --> click on Insert Column or Bar Chart --> select Stacked Column.
This will create a chart where each year is represented by a column, and the sales of each product are stacked within those columns.
If you’re looking for something more advanced than Excel's native charts, consider using an 3rd party data visualization add-on. They can help and offer many advanced charts, including ribbon-like visualizations that can easily showcase year-over-year product comparisons.
Suggestion from my experience:
To create similar https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr in Excel
Watch https://www.youtube.com/watch?v=gnJlRjtdrjc tutorial to get clear understanding.