+ Reply to Thread
Results 1 to 3 of 3

Need Help in plotting the data into graphical representation

  1. #1
    Registered User
    Join Date
    07-11-2014
    Location
    Bangalore, India
    MS-Off Ver
    2010
    Posts
    13

    Need Help in plotting the data into graphical representation

    hi All,

    PFA attached file. I am trying to plot the entire data into one single graph but failing miserably at it. Can anyone help me in getting this accomplished on how to go about it. What I am looking at is say Quarter (Q1, Q2 etc) in X axis, Story points in Y axis and avg hrs in second Y axis. please correct the data set format if needed to guide me here.

    Also, if you feel there is a better way to represent it I am open for it, ideally would like the graph to be in 3D format and not 2D. Thank you in advance, and have a great day ahead
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-11-2014
    Location
    Bangalore, India
    MS-Off Ver
    2010
    Posts
    13

    Re: Need Help in plotting the data into graphical representation

    help anyone?

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,647

    Re: Need Help in plotting the data into graphical representation

    I am not sure what you want the chart to look like, not sure what you mean by 3D instead of 2D, nor is it clear what your desired Y values are. I find that a lot of charting questions really end up being about the spreadsheet and less about the chart. In this case, I think you need to rearrange the data to better. The most common and easiest data arrangement will be to have the desired X values going down the left side of the table, the desired series labels going across the top of the table, with the desired Y values in the body of the table.
    Please Login or Register  to view this content.
    Then use that table to create the desired chart.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Graphical Representation of KPIs
    By shaikhrulez in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-20-2015, 05:21 AM
  2. Want to Make Graphical representation of tables
    By engmhelmy in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-07-2015, 11:42 AM
  3. Graphical representation of multi-level data (pie of pie of pie)
    By dsynadinos in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-16-2014, 01:45 PM
  4. Datewise graphical representation
    By durga_ikon in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-14-2014, 01:14 AM
  5. Graphical representation through line graphs
    By excelvba123 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-25-2013, 08:11 PM
  6. split the excel worksheet in 2 equal parts
    By Pigggy in forum Excel General
    Replies: 1
    Last Post: 01-29-2012, 08:05 PM
  7. Graphical Representation
    By cityinday in forum Excel General
    Replies: 4
    Last Post: 03-19-2006, 12:44 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