+ Reply to Thread
Results 1 to 3 of 3

Chart From multiple sheet of single field

  1. #1
    Registered User
    Join Date
    05-27-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    2

    Chart From multiple sheet of single field

    I have attached an excel sheet
    Consider Students are having exam daily and data is received daily in the format below for different subject
    Sheet-1
    Math
    01-05-20 02-05-2020 03-05-20 04-05-20
    Student A
    Student B
    Student C
    Student D


    Sheet-2
    English
    01-05-20 02-05-2020 03-05-20 04-05-20
    Student A
    Student B
    Student C
    Student D

    Objective :
    i was trying to plot a graph similar to indicated in image
    for single student and its all subject variation on graph

    1. Student A-

    x Axis -Days
    y Axis -Marks of Student-A

    1. can we do it without copy pasting the data of single student in one sheet.
    2. Can we make an dropdown on graph itself for different students

    Excel sheet is attached fro reference
    Thanks in advance
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    848

    Re: Chart From multiple sheet of single field

    Hi Jzaved,
    Have a look at the attached file.
    I have inserted a sheet called Dashboard.
    There you have the chart for the student with the 4 subjects over time.
    You can select the students via the dropdown list in cell C2.
    I have also added some dynamics into the Dashboard so if you add new students on the 'English' sheet, they should be picked up in the dropdown list.
    Not fully dynamic, but should get you started.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-27-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    2

    Re: Chart From multiple sheet of single field

    thanks i have gone though the file. i have presented a sample here,though it works on my real data sets

+ 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. Replies: 5
    Last Post: 04-06-2016, 04:55 PM
  2. Replies: 1
    Last Post: 04-06-2016, 04:39 PM
  3. Export all charts (embedded and single chart sheet) to a single PDF File
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-23-2016, 09:56 AM
  4. Replies: 2
    Last Post: 04-15-2013, 08:50 AM
  5. Replies: 0
    Last Post: 10-10-2011, 05:03 AM
  6. How to draw the multiple chart in single sheet.
    By ramkumar_cpt in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-10-2005, 12:07 AM
  7. Multiple Pivot Tables with single Page Field
    By cscribner in forum Excel General
    Replies: 1
    Last Post: 05-25-2005, 07:27 PM

Tags for this Thread

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