It is not clear to me what you are having difficulty with. A sample file would help, as sandy666 noted.
You say that you want to create a stacked bar chart (your picture is a column chart, but the ideas I suggest are basically the same for column or bar charts) with different data. Charts don't create or analyze data, so the first step to create a stacked chart with different data will be to compute the new data in the spreadsheet. Do you have ranges that compute these "percent of percent" values in your spreadsheet? Have you got these data arranged in a suitable table? I would expect something like:
Select this range and insert your stacked bar or column chart. Format chart elements as desired. It often seems that most of the work is in building the spreadsheet and not in creating the chart.
Can you build a table like that? What would you need help with?
Bookmarks