Aren't Stacked Column charts supposed to stack values for a total per column?

[stuckfly]

I have a table with two columns: one for transaction dates and the other for amounts.
I want a chart that will stack each month's transactions on top of each other to show monthly totals.
Seems like this would be simple, but I'm not a seasoned Excel user.
The closest I can get shows transactions overlapped per month, so as the column for each month shows the maximum transaction as chart column height.
Example:

For December 2019 there is one transaction for $102, for January there are two: $46 and $102.
Both chart columns "stack" to $102. Shouldn't the chart column for January be taller to show $148?
That's what I need…

Any way to do that?
I wouldn't mind a sum label at the top of each chart column, too.

Tried to add an image, but even the smallest cropped screen shot is too large of a file to upload to this board. It's 269KB and barely legible at that size.

 

[MARK858]

I have no issue with it stacking correctly. How have you laid out the data (this seems like your issue as you have stated "I have a table with two columns: one for transaction dates and the other for amounts.", which if I am reading it correctly is not a good layout for a chart)?

Btw you can't upload files and 269Kb is not a large file

 

[MARK858]

If you can't change your data layout then the best that I can suggest is creating a new series using formula then creating the chart from there i.e.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
2	December	102		unique	1	2	3	4	5	6	7	8	9	10	11	12
3	January	102		December	102
4	January	24		January	102	24
Sheet1

Cell Formulas
Range	Formula
D3:D4	D3	=IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($D$2:D2, $A$2:$A$10), 0)),"")
E3:P4	E3	=IFERROR(INDEX($B$2:$B$10, SMALL(IF($D3=$A$2:$A$10, ROW($A$2:$A$10)-MIN(ROW($A$2:$A$10))+1, ""), E$2)),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[stuckfly]

Got it!
Took me awhile.
I noticed that your examples (thank you for saying I cannot upload images show months as categories and not dates or date values, and I eventually paid more attention to your comment about "if I am reading it correctly is not a good layout for a chart."
Makes no sense to show individual transactions stacked up; it's the totals that really matter.
I used another sheet with one row per month and a SUMIF formula in the second column that refers to named ranges in the first sheet to compute totals per month, and now I have the simple chart I want. I abandoned the stacked column in favor of a line chart so I could add a trendline.
In future, if I want to do the stacked transactions per month chart I had envisioned, you've given me the key to do that by setting up each month as a category with each transaction record belonging to a one of them. And I'm betting I could even add a total for each month then, as a category label series.
Many thanks, Mark858!

 

[MARK858]

Your welcome, for the totals see the link below

How to add totals to your stacked chart? - Goodly

Use this simple technique to add total labels to stacked column charts in Excel

www.goodly.co.in

Btw, I didn't state that you can't post images. I stated that you can't upload attachments because you posted

a file to upload to this board.