Forum Discussion
Visualizing Year-over-Year Sales Data with Comparison Chart in Excel
You've had a LOT of views without anybody attempting a reply. Given that there are many folks here on these boards far more knowledgeable about the advanced features of Excel than I, I'm a bit wary of even responding. But, let's give it a try.
First of all, since you have NOT shared any example of how your raw data are arranged, it's kind of difficult to know what function or method (Pivot Table?) could be used to first summarize the data to serve as a basis for the visualization itself. So one thing you could do to help us help you would be to post EITHER the actual spreadsheet you have of sales data over these several years OR (if the actual contains confidential or proprietary data, which is entirely likely) a reasonable mockup that conceals the specifics but does represent accurately how the raw data is arranged. A spreadsheet can usually be posted with a reply, using the area at the bottom of the box where you write your text.
If you're not able to attach directly to your post, you could put a copy on OneDrive or GoogleDrive (or equivalent) with a link pasted here that grants access.
All of that having been said, if for whatever reason you're not willing or able to post such a spreadsheet, I wonder if you're familiar with the dynamic array functions, which are amazingly powerful tools that could be used in combination to produce such things as a custom pivot table, each column being sorted by product with largest sales for the year, and so on.
Himathetes,
Thank you for your reply and willingness to help. I've attached an Excel file with a sample spreadsheet that closely resembles my actual data. I've ensured that the file is in the standard .xlsx format and have removed any sensitive information.
Please let me know if you have any trouble accessing or opening the file. I appreciate your time and look forward to your suggestions or methods that may be helpful for my data visualization.
Thanks,
Qaiser