Hello,
I feel like I'm inundating this website with questions this week and I apologize. I need to create pivot charts that automatically update on one sheet as numbers are entered into the other. The auto update isn't the problem, however the pivot tables that the charts come from is. I have 52 weeks with so many products each and I need the table to reflect for example
| A | B | C |
Week 1 | 6% | 3% | 4% |
Week 2 | 2% | 8% | 6% |
and
W1 | W2 |
A|6% |2% |
B|3% |8% |
C|4% |6% |
Then I need 2 charts that update one that shows by each product by week and one that shows each week by product. WHen I create the pivot table not all the information shows up and then the charts don't populate.
Bookmarks