+ Reply to Thread
Results 1 to 2 of 2

Combining Data on Graph

  1. #1
    Registered User
    Join Date
    06-26-2015
    Location
    IOM, UK
    MS-Off Ver
    Microsoft 365
    Posts
    26

    Combining Data on Graph

    Hello, any graph experts able to confirm if this is possible please?

    Show cumulative data on a stacked bar chart in different colours for 18 different categories.

    With a line chart in the background from another set of data to show the progression vs targets.

    I hope this makes sense example data attached, but if not, please shout!

    Thank you for your time :-)

    Thank you for the tip Pepe, excel now attached.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by voniom; 04-06-2021 at 09:32 AM. Reason: Adding Excel Sheet

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,946

    Re: Combining Data on Graph

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

+ 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. Combining a bar graph with a stacked graph.
    By kp64330 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-20-2018, 09:24 AM
  2. Combining Colours and Existing Values to Create Line Graph
    By anikasen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-07-2016, 04:16 AM
  3. [SOLVED] Combining bar graphs and waterfall graph
    By bluerog in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-02-2015, 12:49 AM
  4. Combining Stacked Bar Graph with Scatter Graph
    By cunningj in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-08-2014, 04:29 AM
  5. Combining a bar graph and line graph with 2 sets of data
    By lynzlou in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-11-2014, 12:49 AM
  6. Combining 2 different types of bar graph
    By Dave in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-22-2006, 08:40 PM
  7. [SOLVED] Can I create graph combining clusted and stacked columns?
    By Robin in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-19-2006, 11:35 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