Need help Stacked BAR chart 2 axis with trend line

[krillin_boi]

Hi there,

Need some help with what i'm trying to do. I'm trying to create a stacked bar chart the invoices broken down by the month. One axis will have the count of transactions and the other will have amount. Also I would like to add a trend line also for each category based on amount. Can someone please help or show me what I need to do. Please see attached. Thanks!

[noboffinme]

Hi krillin_boi,

I've rearranged your data a bit in order to chart it as you asked.

The Columns aren't 'stacked' because you only have one amount per month for Amount & Count.

Let me know if this is suitable or if not, post a before & after of what you need.

Btw, RHS = Right Hand Side of chart, LHS - Left Hand Side.

Cheers