Charts - Merging 2 or more, or manually creating each bar

[javibg6]

[FONT=&quot]Hi!

[/FONT][FONT=&quot]I've been trying to look for a way to "merge" two or more bar charts, with no success over google nor MrExcel.
[/FONT][FONT=&quot]I'm trying to merge two bar charts into one.[/FONT][FONT=&quot]As said, one image > 1.000 words, here's an image of what i want:
[/FONT][FONT=&quot]https://ibb.co/bBkdDFf
[/FONT][FONT=&quot]
[/FONT][FONT=&quot]Creating 3 series and making a stacked bar chart (as proposed here https://imgur.com/dV6aIhT) would do the job, but wouldn't fit my purposes, as I will be having more data in the nearest columns (https://ibb.co/XZYnZ5T), concerning different years, and i want also to show the same chart for all of the columns. I also have the same need in other sheets with different charts, so it would be great to find a solution without having to reorganise the data, or creating auxiliary tables for each year.
[/FONT][FONT=&quot]
[/FONT][FONT=&quot]To sum up:[/FONT]

• Is there a way to build each bar in a chart manually selecting it?
  
• Once i get to the solution, i would also like to ask excel to show the same chart, but getting the data from next column. Is there a way to do so?

[FONT=&quot]
[/FONT][FONT=&quot]Thanks in advance to everyone!
[/FONT]

 

[Fluff]

Cross posted https://www.excelforum.com/excel-ch...r-manually-creating-each-bar.html#post5118979

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[javibg6]

It seems that i'm not allowed to edit my own posts.

As asked, i wanted to add the threads of other forums in which i have posted the same question. For the moment it remains unsolved.

Here are the URLs, as asked:
https://www.reddit.com/r/excel/comments/bio2if/merging_excel_charts/
https://www.excelforum.com/excel-ch...r-manually-creating-each-bar.html#post5118834

Sorry for the inconvenience.