+ Reply to Thread
Results 1 to 4 of 4

Bar graph for text values over years

  1. #1
    Registered User
    Join Date
    11-12-2007
    Posts
    9

    Bar graph for text values over years

    My client wants to chart the various years that missionary organisations maintained certain welfare centres AND, if possible, denote the denomination of that organisation with various colours (see the PDF attached). I'm thinking that Excel might not be the best program to do this with, but thought I would ask in case one of you is inspired! I have tried pivoting data, but the best thing I could come up with was a high/low/close graph which is close, but no medal! Any ideas? Thanks.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-13-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    216

    Re: Bar graph for text values over years

    Hi Dimonds,

    Here is my take on your chart.

    I have grouped the data into categories and made it look like a Gantt Chart.

    If you like this and want to learn more, here is link to a step-by-step and video tutorials for the topics on how I made these:

    This demos the Gantt Chart:
    How-to Make a Basic Gantt Chart in an Excel Chart in 7 Easy Steps

    This demos the Multi-Level Categories on the vertical axis:
    How-to Easily Create a Stacked Clustered Column Chart in Excel

    Here is the sample file: Grouped Missions.xlsx

    Please let me know if this helps.

    Steve=True

  3. #3
    Registered User
    Join Date
    11-12-2007
    Posts
    9

    Re: Bar graph for text values over years

    Wow! That's good - thanks so much. Client is very happy......

  4. #4
    Forum Contributor
    Join Date
    09-13-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    216

    Re: Bar graph for text values over years

    Dimonds,

    That is so wonderful.

    Glad I was able to help.

    Thanks for the feedback.

    Steve=True

+ 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