reporting_95
New Member
- Joined
- May 7, 2019
- Messages
- 30
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hello,
I have about have about 3 years worth of sales data and I'm comparing in-store to online sales. I summarized my data in a pivot table and included two slicers to easily click on a year and month to view the total sales for that period. I'd like to use a graph to show a visual of this data, but the suggested graphs don't exactly capture what I'm trying to display. Can anyone please suggest a better way to graph and visualize this data? I'll include a screenshot of my pivot table and slicers. Thanks!
I have about have about 3 years worth of sales data and I'm comparing in-store to online sales. I summarized my data in a pivot table and included two slicers to easily click on a year and month to view the total sales for that period. I'd like to use a graph to show a visual of this data, but the suggested graphs don't exactly capture what I'm trying to display. Can anyone please suggest a better way to graph and visualize this data? I'll include a screenshot of my pivot table and slicers. Thanks!