+ Reply to Thread
Results 1 to 2 of 2

Complex Stacked Cluster with Secondary Axis

  1. #1
    Registered User
    Join Date
    04-05-2013
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2010
    Posts
    4

    Complex Stacked Cluster with Secondary Axis

    I am trying to create a stacked cluster chart, with a secondary axis to show the second data points. However, I am stuck. I cannot figure out how to place the Opps data in the chart, show a secondary axis, yet still maintain monthly integrity. (Please see attached.)

    I'm using Excel 2013 and have viewed the http://peltiertech.com/WordPress/clu...mn-bar-charts/ link, but it is not helpful.

    What am I missing in order to have:
    Groups
    Opps
    Revenue
    Months
    Many thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Rocester, New York, USA
    MS-Off Ver
    Excel 2007:10
    Posts
    2,019

    Re: Complex Stacked Cluster with Secondary Axis

    It looks like John's mixed column chart is exactly what you want, right? Please expand on what you meant by "not helpful."

    If I'm looking at your data right, isn't the next step for you in the tutorial to split the "Opps" and "Revenue" values into different rows to spoof the clustering?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Stacked bar chart with stacked secondary axis markers - please help!
    By Boardlady in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-22-2013, 10:32 AM
  2. Cluster Column Graph with Secondary Axis
    By apollo1331 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-26-2013, 02:51 PM
  3. Stacked Chart With Secondary Axis
    By MLS Packer Lover in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-19-2012, 12:35 AM
  4. [SOLVED] Cluster charts and the secondary y-axis
    By 8472 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-06-2006, 08:00 PM

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