bar chart formula to show the number growth

Hello,

I have data month by month with titles. How can i produce the Average number of Title growth using stacked bar chart?

Thanks for the help!

Hi,

I presume that those values in your Count column are your averages?

Actually, you're not helping Excel interpret your data for a Stacked Chart by arranging it the way you have. It would be much more helpful (and more logical) if you simply had one entry for each month in your rows and, in place of your Title and Count columns, two columns (e.g. Advisers and Managers) in which to record their respective averages.

In this form Excel can produce the desired Stacked Bar Chart. See the attached.

Hope that helps!