Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or
×

fileKutools Charts - Warning Error

More
3 months 1 week ago #3717 by Dorota
Kutools Charts - Warning Error was created by Dorota
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


 

Please Log in or Create an account to join the conversation.

Moderators: ExcelfansOfficeFansAmanda Lee