+ Reply to Thread
Results 1 to 3 of 3

stacked column with line chart?

  1. #1
    Registered User
    Join Date
    11-09-2006
    Posts
    65

    stacked column with line chart?

    I have a chart that I want to upgrade so that the column data is broken down into 3 colors.
    My orginal chart is pic1. Pic 2 is what I want the column to look like but need to figure out how to add the line section.

    Anyone done this before?
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor
    Join Date
    10-15-2007
    Location
    Home
    MS-Off Ver
    Office 2010, W10
    Posts
    373
    Hi surfengine

    This is a solution.

    1 - Create a simple stacked column chart with the 4 series (the 3 you want as stacked + the one you want as line)

    2 - Right-click on one column on top of the part of the series that you want to be displayed as line and choose Chart Type as Line.

    This gives you the chart with 3 series as stacked column and 1 series as Line.

    However, it may happen that the Y-scale is not convenient to the line, like in your first example, where the line is percentage and the column is value.
    If that's the case,

    - right-click on the line and choose Format Data Series>Axis>Secondary Axis

    This way you read the line values in a different axis that you can scale as you see fit.

    HTH
    lecxe
    Last edited by lecxe; 10-24-2007 at 01:12 AM.

  3. #3
    Registered User
    Join Date
    11-09-2006
    Posts
    65
    lecxe,
    You rock!!

    I cannot believe how simple that was.

+ 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