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

  • Unknown
    Accepted 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'

This discussion has been closed.