+ Reply to Thread
Results 1 to 1 of 1

How a chart can be created for crosspoints in excel from tabular data?

  1. #1
    Registered User
    Join Date
    03-28-2013
    Location
    pune
    MS-Off Ver
    Excel 2010
    Posts
    1

    How a chart can be created for crosspoints in excel from tabular data?

    table contents.pngI have three columns and values as given below
    Date Team 1 Team 2
    3-Apr C B
    4-Apr G E
    5-Apr I F
    6-Apr B H
    6-Apr A E
    7-Apr F D
    7-Apr I G
    8-Apr H C
    9-Apr E B
    10-Apr D A


    How can convert this timetable in crossover table as given below. Is there any function/process in Excel 2010 to create such matrix automatically?

    A B C D E F G H
    A 6-Apr
    B 6-Apr
    C 3-Apr
    D 10-Apr
    E 9-Apr
    F 7-Apr
    G 4-Apr
    H 8-Apr
    I 5-Apr 7-Apr .


    Please see the attached screenshot for exact table contents.

    Thank you for your help.
    Last edited by shreedharn; 03-28-2013 at 05:06 AM. Reason: please find the screenshot for exact table contents

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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