It seems that if I want to create a pivot chart, it's going to select everything from that pivot table rather than allowing me to select certain rows/columns. How can I go about creating a dynamic chart based off certain rows/columns and it will update automatically when new data is entered? Is there some other option?