+ Reply to Thread
Results 1 to 3 of 3

Help creating a graph with 3 variables

  1. #1
    Registered User
    Join Date
    11-15-2014
    Location
    Brazil
    MS-Off Ver
    2013
    Posts
    2

    Help creating a graph with 3 variables

    Hello all.

    I'm having some major difficulties creating a graph with three variables:

    What i need to do (and i can't for my life figure it out), is a way to compare all the possible variations in the file, with all the percentagens of each combination (if i think i'm doing it right, i should end up with a graph with 56 collums).

    Is my assumption right? I'm honestly not all that good with excel, and i dont think i've explained myself all that well (english isn't my main language, i'm brazilian).

    Would anyone be kind enough to enlighten me on this?

    Example_01.xlsx

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Help creating a graph with 3 variables

    Hello,

    the possible combinations are indeed 56, but your data does not use all the 56 different possibilities. To analyze your existing data, you can build a pivot table. Drag the Company and the "Do you compare" field into the rows, drag the Options into the columns area. Then drag the "Do you compare" field into the values area. Now you have a table that shows which options are in the data and how many times they are showing.

    2014-11-23_14-43-54.png

    I'm not sure I understand completely what you would like to achieve, but maybe this can be a starting point for further discussion.

    See attached file.

    cheers, teylyn
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-15-2014
    Location
    Brazil
    MS-Off Ver
    2013
    Posts
    2

    Re: Help creating a graph with 3 variables

    Wow, thanks so much for the super quick response =)

    yes, that's exactly what i wanted done.

    What we mean to do with that info, is stabilish a %, to show customer preferences between airplance companies and the factors that lead them to choose said companies (that spreadsheet is just a small part of my whole... ahn... "last college paper"? you know the last thing you to before you graduate)

+ 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. [SOLVED] Creating a line graph over a bar graph to show actual v.s. goal?
    By nscarritt in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-03-2014, 03:09 PM
  2. 3 variables in 2d graph
    By saeed_azsh in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-17-2013, 04:17 PM
  3. Macro graph - Option to graph certain variables
    By foxy_420 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2013, 03:49 PM
  4. Help with creating a graph with three variables
    By Grish in forum Excel General
    Replies: 0
    Last Post: 08-21-2012, 11:04 AM
  5. [SOLVED] 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

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