+ Reply to Thread
Results 1 to 2 of 2

Showing Millions on one Axis, Percentages on the Other with Clustered Column Chart

  1. 06-09-2017, 07:40 PM #1
    bocorunner
    bocorunner is offline
    Registered User
    Join Date
    06-09-2017
    Location
    Portland
    MS-Off Ver
    2010
    Posts
    1

    Showing Millions on one Axis, Percentages on the Other with Clustered Column Chart

    This simple exercise is stumping me and it is very frustrating.

    I have the following table of info that I want to plot in a column chart (Excel 2010).
    Table1.JPG

    I need to show sales on the left side of the chart and contribution (percentages) on the right.
    Currently, I have the graph below, which I like...I'd like to have the same on the right for the percentages.
    Table2.JPG

    I've spent over an hour trying to format the secondary axis as a percentage, but it is not working. Any insight? Is the data arranged incorrectly in the table? I've rearranged it several times and am not getting anywhere. I am at the point of diminishing returns. Thank you so much for any help!!!
    Reply With QuoteRegister To Reply
  2. 06-13-2017, 12:32 PM #2
    dflak
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Showing Millions on one Axis, Percentages on the Other with Clustered Column Chart

    I'm not quite sure what you are looking for, but what I did here was to plot the two series. I selected the axis and temporarily adjusted the maximum to 1. This allowed me to see the contribution series. I selected the series and put it on the secondary axis. I then reset the original axis to automatic. The I played with the series overlap and gap width so the columns would not eclipse each other.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Clustered bar chart with one group showing as a symbol
    By stat_geek in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-23-2015, 04:08 AM
  2. Clustered column chart (primary and secondary axis)
    By ziad9933 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-30-2014, 05:22 AM
  3. 0% marking on the y axis clustered column chart
    By enialy in forum Excel General
    Replies: 2
    Last Post: 03-18-2012, 07:05 AM
  4. Clustered or stacked column chart showing val 1(total), val 2 (part of A), % 2 of 1
    By rbtroj in forum Excel General
    Replies: 0
    Last Post: 03-02-2012, 12:54 PM
  5. Dual Axis Clustered Column Chart Excel 2007??
    By fcb1900 in forum Excel General
    Replies: 0
    Last Post: 06-22-2010, 09:49 AM
  6. Clustered Column Chart w/ second y-axis
    By Sheri_Eisenvett in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-29-2008, 04:41 AM
  7. [SOLVED] Align Clustered Column Chart Category Axis Labels
    By Stephanie in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-07-2005, 11:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1