Forum Discussion
Pivot by function and graphs.
Hi,
I am trying to make my graph based on a pivot ny function to keep updated. As soon as I Add a new line in my table, the graph gets ruined. See attached document for example.
Any clever solutions for using Pivot by and graphs?
Best regards
- Geir
1 Reply
At first glance, a no fuss work around when adding a new row is to enter 'Project', 'Hours', then 'Customer'. The chart doesn't break.
The problem with charts is the legacy select data menu has been around for ages and wasn't developed with dynamic arrays in mind.
