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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Englert

    Cluster and Stacking Bar Chart

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

    Widening Cluster Chart Columns

    toilinthedark, Oct 31, 2005, in forum: Microsoft Excel Charting
    Replies:
    2
    Views:
    403
    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:
    421
    Debra Dalgleish
    Dec 2, 2005
  5. Guest
    Replies:
    1
    Views:
    381
    Jon Peltier
    Apr 3, 2006
  6. Guest
    Replies:
    1
    Views:
    1,671
    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,483
    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,834
    Andy Pope
    Aug 14, 2008
Loading...