Stop overlapping of stacked columns in chart (Excel 365)

[NVanEngineer]

Hi;
I did see this question asked before, but I couldn't find a thread with a posted answer.
I'm mostly frustrated because I'm 90% sure it's a stupid simple fix, but I can't seem to get it...

I'm trying to copy a graph format from previous reports so that it's consistent.

I've got a stacked bar chart showing production divided into commercial sales and other.

The "other" bar is the top bar, and it's narrower than the bottom bar. It shows an overlap between the top bar and bottom bar. No matter how I adjust the settings, I can't get a clean division between the top bar and bottom bar. I just want the bars to stack exactly - the top bar bottom sitting exactly on the top of the bottom bar.

When I have the bar "width" set to 1 point, there is no overlap, but the bars are too skinny to be consistent. When I set the "width" of the bar in the "border" section on the graph, I can get nice fat bars to be consistent with earlier reports. However, it "fattens" along the top as well, pushing up until the two lines overlap.
Seriously - how hard can it be to have a nice wide column stacking one on the other without this overlap?

I have the Mr Excel HTML Maker, but am not sure how to post a picture of the graph rather than just the table...

If it helps, the table is here:

	B	C	D
3	Year	Commercial Sales (tonnes)	Other sales (tonnes)
4	2005	1,440	1,020
5	2006	3,420	780
6	2007	2,400	2,250
7	2008	1,800	3,000
8	2009	2,262	2,238
9	2010	1,668	6,014
10	2011	1,509	3,413
11	2012	1,128	5,598
12	2013	1,433	5,178
13	2014	1,870	4,063
14	2015	3,075	3,463
15	2016	3,066	1,982
16	2017	3,521	3,408
17	2018	3,255	5,320

<tbody>
</tbody>

Mass flow sheet (2)​

Worksheet Formulas Cell Formula B3 Year C3 Commercial Sales (tonnes) D3 Other sales (tonnes) B4 38353 C4 1440 D4 1020 B5 38718 C5 3420 D5 780 B6 39083 C6 2400 D6 2250 B7 39448 C7 1800 D7 3000 B8 39814 C8 2262 D8 2238 B9 40179 C9 1668 D9 6013.8 B10 40544 C10 1509 D10 3413.4 B11 40909 C11 1128 D11 5598 B12 41275 C12 1432.8 D12 5178 B13 41640 C13 1870.2 D13 4063.2 B14 42005 C14 3075 D14 3462.6 B15 42370 C15 3066 D15 1982.4 B16 42736 C16 3520.8 D16 3408 B17 43101 C17 3255 D17 5319.6 <tbody> </tbody>

<tbody>
</tbody>

I've got the data set up as a stacked column.
The "other sales" line is on the top, and has a width of 3 points, with the "commercial sales" line on the bottom with a width of 8 points.

I'd be happy to post a picture if I knew how.

I'd also be really happy if I'm just being an idiot, and there's an easy way to do this!

Thanks!

 

[Peter_SSs]

I have the Mr Excel HTML Maker, but am not sure how to post a picture of the graph rather than just the table...

You can't with the MrExcel HTML Maker. You can upload an image to a public file-share site and provide a link to that.

Also, when using the MrExcel HTML Maker, use one of the options rather than "All Formulas" to restrict that large table after the worksheet image. In your example there are no actual formulas to show so choose 'No Formulas'