+ Reply to Thread
Results 1 to 6 of 6

Line Graph without numerical values

  1. #1
    Registered User
    Join Date
    04-08-2019
    Location
    Germany
    MS-Off Ver
    2019
    Posts
    3

    Line Graph without numerical values

    I'm want to do game analysis for our volleyball team.

    vballstats.xlsx

    Trying to plot a line graph like the ones you see on tennis matches which players won the last 10-20 points.
    Initially, I wanted to use letters A and B for the teams, but seems like Excel can't work with non numerical values, so now I replaced them with 1 and 0 to represent both teams and the chart attached came out as the result, I guess 2nd best option...

    Now, I want to increase the number of graphs with pie charts to see which player caused what event (error, winner, etc.)
    Tried using Pivot Table or Pivot Chart but no matter how I shift the axis, it's not what I expect.
    Is it even possible to do the graph directly from the table attached? Or would I need another table to do the calculations with IFs and COUNTs?

    Thank you!

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

    Re: Line Graph without numerical values

    Hello Kanito and Welcome to Excel Forum.
    I could not replicate the graph on the Tabelle1 sheet.
    Note that the series name and series values reference a file to which we do not have access.
    The data in rows 1:5 is transposed into cells A16:E76 and then used to produce a pivot table which shows the teams.
    Conditional formatting colors the font and fill of cells that contain 1 (the count of points) to produce a pseudograph.
    On the Pivot Table Pie Chart sheet there are two pivot tables and graphs produced from the data in cells A16:E76 on the Tabelle1 sheet.
    The pivot table/chart on the left displays the percentage of event per player.
    The pivot table/chart on the right displays the number of times a player produced an event.
    Let us know if you have any questions.
    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.

  3. #3
    Registered User
    Join Date
    04-08-2019
    Location
    Germany
    MS-Off Ver
    2019
    Posts
    3

    Re: Line Graph without numerical values

    conditional formatting!!! that's genius and it's a perfect alternative to the graph... 1000 thanks man!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,848

    Re: Line Graph without numerical values

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, if you have not already done so, remember that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Registered User
    Join Date
    04-08-2019
    Location
    Germany
    MS-Off Ver
    2019
    Posts
    3

    Re: Line Graph without numerical values

    done and done! appreciate the help!

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

    Re: Line Graph without numerical values

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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. Updating existing 4 line graph is giving single line graph
    By carrach in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-15-2016, 07:53 AM
  2. Line Graph question - vetical line values at one fixed date
    By bohn in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-12-2015, 02:22 PM
  3. Replies: 5
    Last Post: 03-28-2015, 03:48 PM
  4. How to graph a pivot of non numerical values
    By Profsaid in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-01-2013, 12:02 PM
  5. Unable to graph the desire x values on line graph..?
    By tigertan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2012, 05:04 AM
  6. Replies: 1
    Last Post: 02-25-2011, 06:27 AM
  7. [SOLVED] overcoming zero values in line graph
    By marika1981 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-10-2005, 11:06 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