Forum Discussion
Solved
Need help creating a dynamic graph from data extracted from a pivot table
Hi experts, I have hourly data collected from our shared solar system (14 lots). I can get that data into an excel table easily, then use a pivot table to get it summarised by Date-Month.Day (rather...
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!