Hello,
I have an issue with Kutools charts for Excel. I have two tabs. One tab has source data and the second tab has Kutools charts.
I realized that pivot tables can't be used for some of the kutools charts. For example, Bar with Bubbles chart. Therefore, I used a formula, =A15, =A16, ... to get the cell values from the pivot table. I do not want to have static numbers because I want the chart to update based on any changes in the source table. After creating a chart and trying to add new data to the source data taba I get a message
"Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct."
I am sure that this error I am getting because of the Kutools chart, because when I remove the Kutools chart, I don't get the message and I can add new data to the source tab without getting any warnings.
Could you please let me know if there is any way I could create Kutools Bar with Bubbles chart from pivot table and get no warnings.
Thank you in advance.
Dorota
I have an issue with Kutools charts for Excel. I have two tabs. One tab has source data and the second tab has Kutools charts.
I realized that pivot tables can't be used for some of the kutools charts. For example, Bar with Bubbles chart. Therefore, I used a formula, =A15, =A16, ... to get the cell values from the pivot table. I do not want to have static numbers because I want the chart to update based on any changes in the source table. After creating a chart and trying to add new data to the source data taba I get a message
"Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct."
I am sure that this error I am getting because of the Kutools chart, because when I remove the Kutools chart, I don't get the message and I can add new data to the source tab without getting any warnings.
Could you please let me know if there is any way I could create Kutools Bar with Bubbles chart from pivot table and get no warnings.
Thank you in advance.
Dorota