how do I create a cluster chart?

Discussion in 'Microsoft Excel Charting' started by Guest, Apr 15, 2005.

  1. Guest

    Guest Guest

    How do I create a stacked cluster chart in Excel?
     
    Guest, Apr 15, 2005
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    Guest, Apr 15, 2005
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    JoanH,

    There can be several types of clustered charts in Excel. For example, you
    can have a clustered column which consists of a series of columns. Or, you
    can have a series of bars, which consists of horizonal bars. Finally, there
    are a number of combination charts that could be considered clustered.

    To create a simple clusted column chart, set the data up on your spreadsheet
    in a similar fashion to this (note two columns - one has names, the other has
    data):

    Dave 6
    Frank 4
    Kim 7
    Bill 6

    Assuming the data set above is contained in the range A1:B4, select the
    range. Click on the Chart Wizard icon. Under the standard types tab, choose
    Column -> Clustered Column.

    ----
    Regards,
    John Mansfield
    http://www.pdbook.com


    "JoanH" wrote:

    > How do I create a stacked cluster chart in Excel?
     
    Guest, Apr 16, 2005
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Englert

    Cluster and Stacking Bar Chart

    Englert, Jul 14, 2003, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    1,113
    Andy Pope
    Jul 14, 2003
  2. Guest
    Replies:
    1
    Views:
    1,790
    Debra Dalgleish
    Nov 1, 2004
  3. toilinthedark

    Widening Cluster Chart Columns

    toilinthedark, Oct 31, 2005, in forum: Microsoft Excel Charting
    Replies:
    2
    Views:
    519
    toilinthedark
    Oct 31, 2005
  4. Guest

    Stacked column and cluster column on same chart?

    Guest, Dec 2, 2005, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    464
    Debra Dalgleish
    Dec 2, 2005
  5. Guest
    Replies:
    1
    Views:
    421
    Jon Peltier
    Apr 3, 2006
  6. Guest
    Replies:
    1
    Views:
    1,826
    Andy Pope
    Nov 8, 2007
  7. mmckinlay

    Create a combined Cluster and Stacked Column Chart?

    mmckinlay, Jun 3, 2008, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    1,599
    Andy Pope
    Jun 3, 2008
  8. Confused One

    Can I combine a cluster bar chart and a stacked bar chart in one

    Confused One, Aug 14, 2008, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    1,896
    Andy Pope
    Aug 14, 2008
Loading...