+ Reply to Thread
Results 1 to 2 of 2

WHAT IS THIS CHART?! and how to rebuild it?

  1. #1
    Registered User
    Join Date
    01-09-2015
    Location
    Montreal
    MS-Off Ver
    2013
    Posts
    11

    WHAT IS THIS CHART?! and how to rebuild it?

    Hi, I would like to recreate this type of chart. I have a big table with 1s and -1s. Sectors and dates are my 2 axes. I would like each sector to be on Y axis and dates to be on X axis. If the value for a given sector at a given point in time is a 1, then have the bar in green and if it is a -1, then have the bar in red.

    MicrosoftTeams-image.png

    How would you go about recreating it?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,997

    Re: WHAT IS THIS CHART?! and how to rebuild it?

    What I see in your picture is basically a Gantt chart -- which is really a stacked bar chart. Most of the work is building the the data table that feeds into the chart. If you take good care while building the data table, the chart itself should be straightforward. Here are some examples from the forum of Gantt charts with multiple "stacks".

    https://www.excelforum.com/excel-cha...ml#post4902624
    https://www.excelforum.com/excel-gen...ml#post4872310
    https://www.excelforum.com/excel-gen...ml#post4872310
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Rebuild Index on dBASE files through VBA
    By ImranBhatti in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2020, 08:19 AM
  2. Chart doesn't refresh after VBA rebuild
    By B.Jones in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-07-2014, 05:04 AM
  3. rebuild structure
    By czingishan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-01-2012, 09:47 AM
  4. How to rebuild the graph according the choice of combobox
    By wupanfeng in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 05-06-2010, 03:04 AM
  5. Need to rebuild formula using the value entered into a cell on the
    By Forrest in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2005, 01:10 PM
  6. [SOLVED] Rebuild Array-formulas
    By Sige in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-26-2005, 10:05 AM
  7. [SOLVED] Break down, rebuild a matrix
    By Possum Stu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2005, 06:06 PM

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