Stacked chart assistance

[Michael Abrams]

I am having a difficult time creating a stacked chart.

I have attached the spreadsheet and highlighted what I need vs. what I have.

Actually googled it and followed directions, but I cannot figure out what I am missing.

[HansV]

Click anywhere in the chart.
On the Chart Design tab of the ribbon, click Select Data.
Under 'Horizontal (Category) Axis Labels', click Edit.
Clear the box, point to the cell with 2023 (B1), then click OK.
Select the first series under 'Legend Entries (Series)', then click the down arrow button 'v'.
Click OK.
O'd leave the minimum of the x-axis at 0.

Stacked chart.xlsx

[Michael Abrams]

Thank you HansV so much. Works perfectly.

[Michael Abrams]

I do apologize. Once again, I was not clear.

I need the HP Edits to be part of the Total transactions.

So the blue would be 9,475,702 and the HP Edits would be "part of" the Total transactions. Not "in addition to" the Total Transactions.

I am very sorry for missing that.

Michael

[HansV]

See the attached version.

Stacked chart.xlsx

[Michael Abrams]

Thank you HansV