Forum Discussion
Need help creating a dynamic graph from data extracted from a pivot table
For the chart you may build PivotTable as
with Ratio as
Next add PivotChart, it works dynamically.
For the chart you may build PivotTable as
with Ratio as
Next add PivotChart, it works dynamically.
Thanks SergeiBaklan​ - I think that might be two beers I owe you!
Keep up the good work and best wishes for 2026
RedNectar (aka Chris Welsh)
You are welcome, glad to help. All the best for 2026!
Sorry to be a bother - but do you have any suggestions about solving my next problem?
https://techcommunity.microsoft.com/discussions/excelgeneral/need-help-adding-calculations-to-pivot-chart/4482695/replies/4482743
(Thinking it may have to give up on Excel and use python, or at the very least fire up my Windows VM and use Excel for Windows and try a Power Pivot)
Don't waste time on it if it is a hopeless cause.
