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:
    997
    Andy Pope
    Jul 14, 2003
  2. Guest
    Replies:
    1
    Views:
    307
    Jon Peltier
    Apr 3, 2006
  3. Guest
    Replies:
    1
    Views:
    1,471
    Andy Pope
    Nov 8, 2007
  4. mmckinlay

    Create a combined Cluster and Stacked Column Chart?

    mmckinlay, Jun 3, 2008, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    1,247
    Andy Pope
    Jun 3, 2008
  5. 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,618
    Andy Pope
    Aug 14, 2008
Loading...

Share This Page