Hello,
Hope your day is going well. I have created a stacked column chart in excel for two data sets (i.e., inoculum and endogenous decay) in the attached document. As you will notice, the categories (represented by different colors) for the inoculum have been organized from least to greatest. I would like to do the same with the second dataset and am seeking guidance with doing so. I have tried created separate graphs for both datasets and then copying and pasting one of the charts into the other. However, this has resulted in a single horizontal axis containing both datasets (see the second attached figure).
Thank you in advance for your help. Have a wonderful and productive day!
Sincerely.
