+ Reply to Thread
Results 1 to 5 of 5

need 3 column chart to display ongoing status but can't figure out how to do it

  1. #1
    Registered User
    Join Date
    12-22-2008
    Location
    california
    Posts
    22

    need 3 column chart to display ongoing status but can't figure out how to do it

    I have 3 columns of data.

    1) Category (type of travel company)
    2) Name of Company
    3) status Accepted or completed)

    excel chart example.jpg


    Category >Company >Status
    Ad Agency >Greatest Hotels Group, Inc. >Completed
    Ad Networks >Adslot >Accepted
    Ad Optimization >Merkle >Accepted
    Cruise >Princess Cruises >Completed
    Cruise >Celebrity Cruise Lines >Accepted

    Does anyone know how to make a chart that shows this information graphically?

    My goal is to show how many companies I have in specific categories that have either accepted or completed in the status.

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: need 3 column chart to display ongoing status but can't figure out how to do it

    Can you attach a sample workbook with enough data and maybe a mock up of what you are looking for as a result.

    Go Advanced -> Manage Attachments -> Upload

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,083

    Re: need 3 column chart to display ongoing status but can't figure out how to do it

    I would suggest a simple pivot chart with the count of company name as the data.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  4. #4
    Registered User
    Join Date
    12-22-2008
    Location
    california
    Posts
    22

    Re: need 3 column chart to display ongoing status but can't figure out how to do it

    see attached example

    I'd like to see the category column (A) on the X axis with (2)stacked columns next to each other
    representing column B & C (Completed & Accepted). I'm unclear how to incorporate the name of the company into the chart. That's above my head
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,123

    Re: need 3 column chart to display ongoing status but can't figure out how to do it

    Here is my interpretation of Don's suggestion about using a pivot table and chart.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 09-11-2014, 04:32 PM
  2. [SOLVED] Ongoing line or scatter chart, don't want bar to drop to zero on blanks
    By Catalytic in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-29-2014, 12:25 PM
  3. Replies: 3
    Last Post: 08-15-2013, 08:03 PM
  4. Replies: 4
    Last Post: 04-08-2012, 09:43 PM
  5. Display the latest figure in a column??
    By MJK in forum Excel General
    Replies: 4
    Last Post: 08-06-2008, 10:08 AM
  6. [SOLVED] How to incorporate and display % in Column chart?
    By suvransu in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-13-2005, 07:06 AM
  7. Display No. of Rows in Status Bar
    By Marty in forum Excel General
    Replies: 2
    Last Post: 01-24-2005, 07:06 PM

Tags for this Thread

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