+ Reply to Thread
Results 1 to 4 of 4

How to set up a bar chart with multiple sets of data

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    50

    How to set up a bar chart with multiple sets of data

    Hello,

    In the attached workbook is the raw data that I want to use to create a bar chart. The first column of raw data is the "Program" and the second column is "Cycle Time". I want all Programs starting with 1 to be grouped together on the chart (i.e., 101, 102,103) in the same color. Could someone help me arrange such a chart?

    Thank you!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-27-2009
    Location
    Surat,India
    MS-Off Ver
    Excel 2007
    Posts
    52

    Re: How to set up a bar chart with multiple sets of data

    PFA..

    Is it what you require?

    Regards,
    Vishnu
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-16-2013
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: How to set up a bar chart with multiple sets of data

    No, sorry for not being clear. I want each individual program/cycle time to show up alongside each other. but I would like to see them appear clustered in groups of three - i.e. all programs in the 100's joined in a cluster. Hopefully that clarifies.

  4. #4
    Registered User
    Join Date
    03-27-2009
    Location
    Surat,India
    MS-Off Ver
    Excel 2007
    Posts
    52

    Re: How to set up a bar chart with multiple sets of data

    You can do it with putting a blank row in between groups and then format series with no gap in between.
    PFA.
    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)

Similar Threads

  1. Chart using Multiple Data Sets and Dropdowns...
    By HARDING22 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-03-2012, 02:44 PM
  2. Chart using Multiple Data Sets and Dropdowns...
    By HARDING22 in forum Excel General
    Replies: 0
    Last Post: 04-02-2012, 06:45 PM
  3. [SOLVED] how to chart multiple sets of data quickly
    By xelhelp in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-22-2011, 02:51 PM
  4. dynamic chart for multiple data sets
    By jrtaylor in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-13-2011, 10:36 PM
  5. Creating a chart with multiple data sets
    By poboy2214 in forum Excel General
    Replies: 1
    Last Post: 03-08-2010, 02:09 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