• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data Table

M

meami111

New Member
3 Questions:
1. Can we link the column headers/data of a data table to make it dependent on another table (say a PIVOT table)
2. Can we put a named range as the Data range for the table such that it remains constant when the dependent data in table changes?
3. How can we put reference of data table in a chart such that it updates automatically?

Thanks in anticipation
 
If I understand correctly the questions:
  1. You can't make formulas in table headers, so "no" you can't make them dependent
  2. Question in not that clear, but the table won't resize automatically with a formula. So how would that work?
  3. That would be a native behaviour of a chart based on table data
 
You must log in or register to reply here.
Back
Top