+ Reply to Thread
Results 1 to 7 of 7

Convert Chart Creation Macro to Stacked Column Chart

  1. #1
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Convert Chart Creation Macro to Stacked Column Chart

    Attached is a file with 3 sheets.

    12-31-2014 - Dated raw data sheet from which summary charts are being derived on other sheets.

    SummaryOLD- this sheet is a manual summary of the key data from the sheet above. CLICK in any cell in column A and chart I've designed pops up showing a column chart with the total values for each year for the row you clicked. You can shift-click multiple cells in column A and get multiple charts side by side.

    This works as desired.

    Summary - this is the new sheet I'm trying to enhance and I've hit a wall. This sheet has the same summarized data in the first few columns, but over in the columns AA and over I've collected and sorted the individual rows that make up that summary data.

    Click on any cell in column A and you will see a multi-column bar chart. If the person you click has more than one event in the sorted data over in AA, you will get multiple columns.

    Problem:
    The FUNCTION of this sheet is exactly what I want. But the CHART is not. I do not want to create side-by-side column bars, I want to create a StackedColumn chart, showing a single bar for each year with the portions stacked together.

    I've Googled and searched and can find no way to create the same exact layout chart I have on my SummaryOLD (single bar for each year, title at the top with the manager and the employee name) on my new Summary but as a standard StackedColumn chart to show all events in a single bar.


    A bonus would be to get the $ amounts to list on the bar:
    http://screencast.com/t/4jGQlIJhV8

    All the code is in the sheet modules.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

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

    Re: Convert Chart Creation Macro to Stacked Column Chart

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Convert Chart Creation Macro to Stacked Column Chart

    Andy, thanks for jumping in. In all my Googling I never saw that syntax suggested so was excited to see that option. But I get a runtime error when I try it:
    http://screencast.com/t/OXor9GDqu

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

    Re: Convert Chart Creation Macro to Stacked Column Chart

    Works for me in xl2010
    Attached Files Attached Files

  5. #5
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Convert Chart Creation Macro to Stacked Column Chart

    Andy, thanks so much. Apparently I've completely lost the ability to cut and paste. (shame)

    I'm trying to make sure I identify all your edits, will fine-tooth-comb it and learn what is up. Thank you, thank you!

  6. #6
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Convert Chart Creation Macro to Stacked Column Chart

    Ah, quick followup, since I'm in needy mode.

    The original charts on SummaryOLD have the chart title at the top automatically without me having had to do anything.

    On the new Summary I was hoping the successful conversion to the StackedColumn would put that title back on top automatically, too. That didn't happen.

    I tried adding this:
    Please Login or Register  to view this content.
    ...but got an error on the second line.

    This works, but puts a small title below instead of the nice big title at the top:
    Please Login or Register  to view this content.

  7. #7
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Convert Chart Creation Macro to Stacked Column Chart

    Grr... finally got it. (headbang)

    Please Login or Register  to view this content.

+ 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. How to add target line to stacked column pivot chart chart
    By oleg mirzaev in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-04-2013, 07:46 AM
  2. How to set the distance between chart series in stacked column chart
    By Jan Zitniak in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 04-23-2013, 03:58 AM
  3. [SOLVED] Stacked Column Chart / Normal Column Chart
    By Rowan Drummond in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-08-2006, 12:00 AM
  4. [SOLVED] How can I add a line chart in a stacked column chart style?
    By Guilherme Loretti in forum Excel General
    Replies: 0
    Last Post: 08-02-2006, 08:50 PM
  5. [SOLVED] To create a stacked column chart and group the stacked bars togeth
    By Jacqueline in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM

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