+ Reply to Thread
Results 1 to 3 of 3

Combine Line Graph & Stacked Column Graph

  1. #1
    Registered User
    Join Date
    06-21-2015
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    6

    Combine Line Graph & Stacked Column Graph

    Hi All

    I require assistance.

    I need to combine a Pivot Line graph and a Pivot Stacked Column graph onto one graph, is this possible?
    How can I achieve the same?

    Thanks

    Regards
    Celeste

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,231

    Re: Combine Line Graph & Stacked Column Graph

    Hi Celeste,
    Yes it is possible.
    Create a stacked column (or bar) graph for all series and then select the series you want to present as line graph, choose "change graph type" and select "line graph".
    As only one series was selected, graph type change will be applied only to this selected series and all other will remain stacked column/bar.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    06-21-2015
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    6

    Re: Combine Line Graph & Stacked Column Graph

    Thank you Kaper, I will give it a try.

+ 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. Combo chart - line graph and stacked column - lines not visible
    By marilyn23 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-02-2014, 12:24 AM
  2. [SOLVED] 3 axis chart with stacked bar graph and line graph above
    By hefe_espada in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-26-2013, 12:53 PM
  3. [SOLVED] I want to combine a line into a column graph
    By quantumag in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-07-2013, 01:35 AM
  4. How to combine one segmented column graph with line graph in one chart
    By hamood83 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-26-2007, 03:19 AM
  5. Creating a graph similar to a stacked column graph
    By Jonathan in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-04-2006, 11:30 AM
  6. How do you combine a stacked column and single column graph?
    By Charlotte C in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-03-2005, 09:10 AM
  7. [SOLVED] How do i add a line graph onto a stacked column chart using data
    By Nicola in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-06-2005, 11:05 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