+ Reply to Thread
Results 1 to 2 of 2

bar chart formula to show the number growth

  1. #1
    Registered User
    Join Date
    07-01-2010
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    50

    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!
    Attached Files Attached Files

  2. #2
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,717

    Re: bar chart formula to show the number growth

    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!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1