Hi!
I've been trying to look for a way to "merge" two or more bar charts, with no success over google nor MrExcel.
I'm trying to merge two bar charts into one.As said, one image > 1.000 words, here's an image of what i want:
merging-charts.png
Creating 3 series and making a stacked bar chart would do the job, but wouldn't fit my purposes, as I will be having more data in the nearest columns , 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.
As asked, here's a kick excel sheet which shows the data, what i'm obtaining, and what i want to get:
charts1615.png
To sum up:
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?
Thanks in advance to everyone!
PD: I posted the same question in other forums, because it's been a while since i posted the first one and i didn't get the solution i wanted, so i tried in different communities. Once I get the solution i will post it in every thread so everyone can benefit from it.
It seems that i'm not allowed to post any URL for the moment as asked in a reply, so i the only way i figured out to do so is by attaching a text file with them.
Bookmarks