This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I am using the data analysis histogram.
I am running the histogram from a pivot table.
When I update my data. then refresh my pivot table,
it does not seem like my histogram/histogram data gets updated.
Should it update?
Is there a way to make it update?
thanks
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Histograms created by the Data Analysis tool are static, not dynamic.
A workaround is to use a data table (Data ribbon > What-If Analysis > Data Table) to create the frequency distribution and use a Column chart type (referencing the frequency distribution) for the histogram.
- Mike Middleton, www.MikeMiddleton.com
For information related to Pivot table in Excel you may post your query in the link below: