+ Reply to Thread
Results 1 to 2 of 2

how to make a comparison column chart between 2 variables

  1. #1
    Forum Contributor
    Join Date
    06-19-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2019
    Posts
    151

    how to make a comparison column chart between 2 variables

    Hi.

    I am looking to make a graph which compares 2 variables very quickly but im not sure how i can do this on excel.

    I have attached an example, please could someone advise.

    Kind regards.
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: how to make a comparison column chart between 2 variables

    If the data is 'pivoted' then perhaps a 100% stacked bar chart, as modeled in the attached file, will work.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. 2 data sets 1 chart (best, column bar) with legend for comparison
    By llyod276 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 12-12-2018, 06:50 AM
  2. Need to make a Chart with Multiple Variables Need Suggestions
    By e4excel in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-15-2018, 03:53 AM
  3. Replies: 9
    Last Post: 07-12-2016, 12:30 AM
  4. Replies: 3
    Last Post: 08-17-2013, 05:13 AM
  5. [SOLVED] Help to Chart Comparison Data of 2 sets of data with 5 variables each needed please
    By bluejasmine in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-13-2012, 12:45 PM
  6. [SOLVED] Dynamic Name range with comparison of variables in column
    By cceze in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2012, 12:14 AM
  7. [SOLVED] How do I make a stacked column chart with side-by-side comparison.
    By Tim in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-08-2005, 11:05 PM

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