Stop overlapping of stacked columns in chart (Excel 365)

NVanEngineer

New Member
Joined
Jul 30, 2019
Messages
1
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:

BCD
3YearCommercial Sales (tonnes)Other sales (tonnes)
420051,4401,020
520063,420780
620072,4002,250
720081,8003,000
820092,2622,238
920101,6686,014
1020111,5093,413
1120121,1285,598
1220131,4335,178
1320141,8704,063
1420153,0753,463
1520163,0661,982
1620173,5213,408
1720183,2555,320

<tbody>
</tbody>
Mass flow sheet (2)

Worksheet Formulas
CellFormula
B3Year
C3Commercial Sales (tonnes)
D3Other sales (tonnes)
B438353
C41440
D41020
B538718
C53420
D5780
B639083
C62400
D62250
B739448
C71800
D73000
B839814
C82262
D82238
B940179
C91668
D96013.8
B1040544
C101509
D103413.4
B1140909
C111128
D115598
B1241275
C121432.8
D125178
B1341640
C131870.2
D134063.2
B1442005
C143075
D143462.6
B1542370
C153066
D151982.4
B1642736
C163520.8
D163408
B1743101
C173255
D175319.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!
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,400
Office Version
  1. 365
Platform
  1. Windows
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'
 

Watch MrExcel Video

Forum statistics

Threads
1,127,616
Messages
5,625,873
Members
416,141
Latest member
Bartek9q

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top