Can we make a stacked bar (y-axis_ with different columns)
I'm making a stacked graph. I have date on my x-axis. I want to add different columns on my y-axis ( I've got 3 columns, Product X sales, Product Y sales, and Product Z sales).
Example:
Product X Sales in January: 3
Product Y Sales in January: 6
Product Z Sales in January: 1
So on the satcked bar, for January I want to see a total of 10, with each product broken down.
Can I do that ?
(p.s Reminder, the sales are 3 different columns)
Best Answer
-
Attached a screenshot of the solution.
In Summary,
1. Under Date Properties, "Graph by" - Set to Month for the monthly view.
2. Chart Type: Stacked bar.
3. In Properties, Data Label Settings, Tick the "Show Total Label" to view the total sales by month.
4. Use the 3 Product sales columns across the Series and Y-Axis.
Hope this Helps!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0
