2 series not proportionate

evolutionx

New Member
Joined
Dec 6, 2024
Messages
2
Office Version
  1. Prefer Not To Say
Platform
  1. Windows
Hi, I have created 2 charts in excel, with 2 series.

1st series is in number, and the other is in percentage.

For the 1st chart (total 5 pax) that I created, the 2 series are proportionate to each other.

1 pax = 20%
4 pax = 80%

1733478036717.png


For the 2nd chart (total 3 pax) that I created, the 2 series are not proportionate to each other:

1 pax = 33%
but the 1 and 33% are not align to each other.

1733477929090.png


also, how do I get the blue and orange bars to overlap each other?

1733478329937.png

no matter how I adjust at the series overlap, it does not change anything.

Hope anyone can help me out with this please, thank you.
 

Attachments

  • 1733477669169.png
    1733477669169.png
    24.4 KB · Views: 0
  • 1733477738678.png
    1733477738678.png
    12 KB · Views: 0
  • 1733477885042.png
    1733477885042.png
    21 KB · Views: 0
  • 1733478305913.png
    1733478305913.png
    12.1 KB · Views: 1

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Forum statistics

Threads
1,224,559
Messages
6,179,515
Members
452,921
Latest member
BBQKING

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
Back
Top