Forum Discussion
How to create several graphs from one Pivot
Hi MStradalen
when you say you want to present five different business units I assume that you need to filter the pivot table by business unit, right?
If so, it's not possible to have several different pivot charts because every applied filter in a pivot table affects directly every pivot chart - and vice versa. In other words, every pivot chart for a different business unit needs it's own pivot table.
Hi MStradalen
when you say you want to present five different business units I assume that you need to filter the pivot table by business unit, right?
If so, it's not possible to have several different pivot charts because every applied filter in a pivot table affects directly every pivot chart - and vice versa. In other words, every pivot chart for a different business unit needs it's own pivot table.
Hi Martin_Weiss! You got my question right. Okay, then I understand why I couldn't manage the task, thank you so much for your help!
Best regards,
Maria