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.
For the chart you may build PivotTable as
with Ratio as
Next add PivotChart, it works dynamically.