+ Reply to Thread
Results 1 to 5 of 5

Need to make a Chart with Multiple Variables Need Suggestions

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Need to make a Chart with Multiple Variables Need Suggestions

    Dear Forum,

    I need to make a chart with Multiple Variables where I need to depict the Sanction Values in Crores & Application nos for three different Channels and then along-with that I also want to show the Male and Female Population.
    Is this possible to achieve all these variables, in all there would be 3 sets of Application nos and 3 Sets of Sanction Amounts for 3 different channels and also the Male and Female population in a stacked column chart.

    Please give some suggestions, do not make charts often,

    Regards
    e4excel

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

    Re: Need to make a Chart with Multiple Variables Need Suggestions

    Do you want the answer in one sentence or can we use two? Really, you've been around here long enough to know that a question with that kind of complexity cannot be answered without sample data and a lot more explanation. Post a file with data for all the variable types and explain in context.

  3. #3
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Need to make a Chart with Multiple Variables Need Suggestions

    Quote Originally Posted by teylyn View Post
    Do you want the answer in one sentence or can we use two? Really, you've been around here long enough to know that a question with that kind of complexity cannot be answered without sample data and a lot more explanation. Post a file with data for all the variable types and explain in context.
    Dear Teylyn,

    I completely agree that I needed to attach the file, however due to IT restrictions at work I could not attach a sample file. I am attaching a file for reference now. As explained I have business from three different Channels with the Application Nos and Sanction Nos and also the Population in that Region both Male and Female and Total Population. I need some suggestions how can I create a Chart which can depict this information in a succinct manner. Now the Population is a large number while Business Nos are in Crores and the Application Nos are general numbers.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Need to make a Chart with Multiple Variables Need Suggestions

    Dear Forum,

    Can anyone give any suggestions based on the shared data

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

    Re: Need to make a Chart with Multiple Variables Need Suggestions

    I thought I had posted this before, but my computer crashed and maybe I didn't. So here again:

    What question should the chart answer? Just "have data, want chart" will not get you very far. What insight will a chart provide? What aspect of the data do you want to tell a story with? What is that story?

    You could mock up a chart with the drawing tools to give us an idea what kind of chart you want, and then we can help you make that happen. But you will have to tell us what the chart should be about, not the other way around.

+ 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. Multiple Criteria, Multiple Variables, 1 Chart, 2 different chart types
    By mysticmoron109 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-21-2018, 05:32 PM
  2. Column chart with multiple variables
    By Keppie89 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-01-2016, 07:19 AM
  3. Replies: 9
    Last Post: 07-12-2016, 12:30 AM
  4. Chart with multiple variables
    By sarinky in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-07-2014, 04:48 AM
  5. Help - Chart Multiple Variables
    By nangys in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-05-2014, 05:26 PM
  6. Excel 2007 : Need to chart multiple variables
    By jscardi in forum Excel General
    Replies: 1
    Last Post: 03-11-2011, 03:09 PM
  7. Chart multiple variables
    By jscardi in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-11-2011, 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