+ Reply to Thread
Results 1 to 3 of 3

Need to pick data from main chart to 4 auto generated sub chart based on 2 criteria

  1. #1
    Forum Contributor
    Join Date
    03-28-2016
    Location
    india
    MS-Off Ver
    2013 (in 2023)
    Posts
    134

    Need to pick data from main chart to 4 auto generated sub chart based on 2 criteria

    Hi good after noon,

    I am filling material processing transactions entry chart with Send from, send to, material name, date, dc no & quantity details as per attached excel file >> sheet name "Input data"
    I want to separate those information to another 4 charts based on material name & send to cell values as per attached excel file >> sheet name "Output data"
    Also i have added data validation in input data chart for avoiding any spelling mistakes in criteria columns. Kindly help me to give your valuable formula for the 4 charts mentioned in sheet name "Output data"
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,918

    Re: Need to pick data from main chart to 4 auto generated sub chart based on 2 criteria

    Here's a sol'n using tables:
    Output data A4 (similar for other columns):
    Please Login or Register  to view this content.
    Notice dropdown dv's in A2 & B2
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    03-28-2016
    Location
    india
    MS-Off Ver
    2013 (in 2023)
    Posts
    134

    Re: Need to pick data from main chart to 4 auto generated sub chart based on 2 criteria

    Dear Proton Leah,

    Thank you for you quick and smart formula to solve my query.
    You are simply master mind...

+ 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. Extract Y-axis auto generated data buckets from chart?
    By icyrius in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2018, 08:29 AM
  2. Which Chart to pick for this data?
    By Snaffels in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-19-2015, 05:12 PM
  3. Erratic Chart Generated from Data
    By Pete291 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-01-2014, 06:42 PM
  4. Cannot get line chart to auto format Y axis based on data.
    By Torinoman911 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2013, 06:40 PM
  5. Replies: 5
    Last Post: 12-05-2012, 12:07 PM
  6. Dynamic Chart(s) that pick up isolated data based on cell entry
    By ObiWanBaloney in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-07-2012, 05:42 AM
  7. need excel chart to pick up data in a certain way
    By excelguru in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-04-2007, 06:54 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