+ Reply to Thread
Results 1 to 3 of 3

Multiple column chart types

  1. #1
    Registered User
    Join Date
    12-05-2007
    Posts
    7

    Multiple column chart types

    I'm trying to create a chart (excel 2007) with 2 different column types on the same graph.

    I need to compare a planned monthly activity figure with an actual monthly activity figure.

    The actual monthly activity figure is made of 2 figures (called first and follow ups) and i would like to plot these 2 series as one column, next to the planned activity series as a seperate column.

    I also have a variance figure plotted on a secondary axis - which is a percentage.

    I can't work out how to get the columns as i want. Any help would be appreciated. I've done a really quick drawing in paint and attached it to better explain what i'm trying to do. I have everything apart from the combined first and follow up bar. I can't seem to get that working.

    Thanks in advance


    Edit: As i wrote this i had a thought. All i really need to know is how to get two seperate sets of stacked columns next to each other.
    Attached Images Attached Images
    Last edited by figolamingo; 10-03-2008 at 03:59 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436
    Instructions can be found here
    http://peltiertech.com/WordPress/200...column-charts/
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    12-05-2007
    Posts
    7
    Thanks a lot, that's exactly what i was after.

    Thanks again

+ 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 draw stacked column chart
    By mpgutta in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-11-2008, 09:19 AM
  2. Macro for coding an action based on 3 columns of information
    By chozen86 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-31-2008, 10:44 PM
  3. Request_stacked column chart
    By Migou in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-10-2008, 12:04 PM
  4. Going insane!
    By kik in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 01-31-2007, 08:21 AM
  5. Merge multiple rows with <alt-Enter> intact
    By RobertCo in forum Excel General
    Replies: 5
    Last Post: 12-14-2006, 03:02 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