Forum Discussion
Visualizing Year-over-Year Sales Data with Comparison Chart in Excel
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
This is no more elegant, even though it does manage to cram those three SORT(FILTER functions into a single HSTACK and do it all as "one formula" So I'll keep playing. Thank you for the opportunity.
=HSTACK(
SORT(FILTER($B$2:$C$19,$A$2:$A$19="Y-2022"),2,-1),
SORT(FILTER($B$2:$C$19,$A$2:$A$19="Y-2023"),2,-1),
SORT(FILTER($B$2:$C$19,$A$2:$A$19="Y-2024"),2,-1)
)
My suspicion is that the PIVOTBY function may be one that would work--maybe even with your raw data-- but that's only available currently in Beta.
Once again, all of the dynamic array functions are explained in this on-line resource.
- Qaiser_jSep 09, 2024Brass ContributorI express my sincere gratitude for your assistance in this matter.
I comprehend your explanation regarding the data transformation process. However, I kindly request a chart or visualization that aligns with the example provided in my initial inquiry.
Thanks- mathetesSep 09, 2024Silver Contributor
I am going to have to defer to some of the other folks in this forum. I do apologize, if it was the visualization in particular that you were seeking help with. I was obviously focusing exclusively on the data side of things.
I just don't do much, haven't for years, with graphic representation of data. In fact, I would have to play around with the options available under the Insert tool bar icons, at least as much as you would have to, if not more.
Given your awareness of what can be done with Power BI, I suspect you're way ahead of me.
But perhaps one of the other Excel forum volunteers can chime in with the appropriate method. Best wishes.