+ Reply to Thread
Results 1 to 3 of 3

Stack-Line Chart

  1. #1
    Registered User
    Join Date
    11-02-2006
    Location
    Pakistan
    Posts
    33

    Smile Stack-Line Chart

    Hi All !

    I want to make a chart which should show data in Stack+lines for following data. Two series should be stacks & other two should be in lines. Chart should be on two axes. Data is as under.

    Jan-09 Feb-09 Mar-09
    D-1 1 2 4 It should be Stack bar.
    D-2 3 4 6 It should be Stack bar.
    D-3 5 6 10 It should be line.
    D-4 7 8 12 It should be line.

    It is easy for the chart type Line-Column on 2 Axes but it does not allow two make it as stack+ line chart.

    Is it possible two make such chart or not?

    Cheers
    Last edited by Reyan123; 01-05-2010 at 01:41 AM.

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

    Re: Stack-Line Chart

    Ignore the built-in combination charts.

    Create a stacked column chart on all four data series.
    Then select one of the series to move to the secondary axis.
    Then move the other series.

    Now change those 2 series to be stacked lines.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-02-2006
    Location
    Pakistan
    Posts
    33

    Re: Stack-Line Chart

    Thanks a lot Andy. The problem has been solved.

    Cheers

+ 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