Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: 2 Variable Stacked Bar Graph? A Challenge!! ;-)

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi everyone--

    Here's a challenge. (Actually, more a desperate plead for help!) I'm trying to create a graph that would have two stacked bars for one variable.

    For example, along the left side of my data I have a number of different products. Along the top, I've got Sales Dollars in East, Sales Dollars in Central, and Sales Dollars in West. Also along the top, I've got Customers in East, Customers in Central, and Customers in West. Each cell would have a value for each product.

    What I'm trying to do is have two stacked graphs for each product, side by side. (One for sales, and one for # of customers, with the product only being displayed once, if possible.) Each graph would have it's own set of values; i.e. sales along the left side of the chart and # of customers along the right.

    Is there ANY way to make this happen? I've tried just about everything I can think of. Any help would be REALLY appreciated!

    Thanks in advance!
    Mike

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Mike,

    Examples are found on these two websites. Both have downloads available. I think Stephen's is called FunChart4

    http://www.stfx.ca/people/bliengme/ExcelTips

    http://www.BMSLtd.co.uk

    HTH,
    Jay

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •