+ Reply to Thread
Results 1 to 2 of 2

Excel Graph

  1. #1
    Registered User
    Join Date
    10-30-2011
    Location
    Silicon Valley
    MS-Off Ver
    Excel 2003
    Posts
    1

    Excel Graph

    I have quarterly data for iPod, iPhone, and iPad per quarter for 2010 and 2011.

    Say data look like this:

    iPod
    (2010) Q1: 10 Q2: 10 Q3: 10 Q4: 10
    (2011) Q1: 14 Q2: 14 Q3: 14

    iPhone
    (2010) Q1: 15 Q2: 15 Q3: 15 Q4: 15
    (2011) Q1: 20 Q2: 20 Q3: 20

    iPad
    (2010) Q1: 13 Q2: 13 Q3: 13 Q4: 13
    (2011) Q1: 15 Q2: 15 Q3: 15


    I want to create a stacked bar graph by quarter (4 quarters)
    And each quarter, I want to compare 2010 stacked data vs 2011 stacked data.

    Truly appreciate it.

    Thanks!

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Excel Graph

    Hello,

    sounds like you want a clustered stacked chart. This is not a chart type that Excel offers out of the box. You need some careful data arranging and a few tricks from the charting toolbox. Jon Peltier has a very good tutorial here:

    http://peltiertech.com/WordPress/clu...mn-bar-charts/

    cheers,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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