+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : How to create composite bar graph with pivot charts

Hybrid View

  1. #1
    Registered User
    Join Date
    03-04-2008
    Posts
    27

    How to create composite bar graph with pivot charts

    Hey all,

    I was wondering if anyone might be able to help me (or tell me if it's not possible) design a composite bar graph using pivot table/charts.

    To summarize really quickly, I have a table with entries categorized by month and rating. So on the chart, I have the axis as the month, with the values being the count of the entries. What I'd like, if possible, is to overlay a color on that count graph that shows the quality. So in other words, if there are only two choices for quality: 1 and 2, and there were 10 entries for January, with 8 being quality of 2, the graph would look like this:

    ---------------------------------
    |///1/// | /////////// 2 /////////// |
    ---------------------------------

    Hopefully that makes sense....

    Any guidance and help is greatly appreciated. Thanks!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: How to create composite bar graph with pivot charts

    Hard to say without seeing your data construction and PT.

    But try adding the Quality field to the Column. This should give you the 2 series.
    Then change the chart type to stacked bar.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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