+ Reply to Thread
Results 1 to 2 of 2

Is there a way to plot a chart with different sets of data per column? (Example included)

  1. #1
    Registered User
    Join Date
    06-07-2013
    Location
    USA
    MS-Off Ver
    Office 2013
    Posts
    14

    Is there a way to plot a chart with different sets of data per column? (Example included)

    Something like this:
    Capture.PNG

    I just changed the colors of the cells, but a chart would be ideal, since I'll be working with a lot of data points.

    The point is to separtate a project on two levels, so you have A-C but within the letters there are subtasks.

    I haven't been able to find anythink like this and was just wondering if anyone would have any ideas about how to go about making something like this, or if it is evel possible at all.

    Thanks!

    EDIT: Kind of like a gantt chart, which uses stacked bar chart, but not exactly the same
    Last edited by kyles123; 07-28-2014 at 04:56 PM.

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

    Re: Is there a way to plot a chart with different sets of data per column? (Example includ

    Have a look at this "floating column charts" tutorial and see if you can adapt it to your needs: http://peltiertech.com/Excel/Charts/...ngColumns.html

    In many ways, your picture looks something like what he describes as a "Gantt chart", so you might follow some of the links to those discussions.
    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. Replies: 3
    Last Post: 08-15-2013, 08:03 PM
  2. Replies: 1
    Last Post: 06-14-2013, 03:40 AM
  3. Plot two sets of Data into one chart
    By e@london in forum Excel General
    Replies: 1
    Last Post: 08-21-2012, 09:04 AM
  4. How do I plot multiple data sets on a whisker chart?
    By Zahra in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-19-2012, 11:11 AM
  5. Plot 3 sets of data in scatter chart and area chart in one
    By geoffs52 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-24-2009, 04:42 AM

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