Hi,
I have a pivot table with country name on one column and corresponding count of products on another column. I have plotted pie chart for the same which gets updated with changes each time i refresh the pivot table.I have declared country names as a dynamic range list in another sheet( known as control sheet where adding names or deleting names is reflected everywhere).
The problem is whenever i add a new country name to the control sheet and data entries are made corresponding to it, the pivot table reflects the new country name and the count of the corresponding products perfectly well. But the pie chart goes out of range and does not extend to the new country which pivot table includes at the bottom.
Kindly suggest how can i make the pie chart extend the range each time a new country is added. I have been instructed to use only one table per chart, hence wont be able to mirror the pivot table to normal table and then work on it
I have a pivot table with country name on one column and corresponding count of products on another column. I have plotted pie chart for the same which gets updated with changes each time i refresh the pivot table.I have declared country names as a dynamic range list in another sheet( known as control sheet where adding names or deleting names is reflected everywhere).
The problem is whenever i add a new country name to the control sheet and data entries are made corresponding to it, the pivot table reflects the new country name and the count of the corresponding products perfectly well. But the pie chart goes out of range and does not extend to the new country which pivot table includes at the bottom.
Kindly suggest how can i make the pie chart extend the range each time a new country is added. I have been instructed to use only one table per chart, hence wont be able to mirror the pivot table to normal table and then work on it
