Forum Discussion
How to create several graphs from one Pivot
Hi!
I need help with creating several graphs from one single Pivot chart. My Pivot chart consists of five different business units that I want to present seperately in five different graphs using the same filter with the purpose to simplify comparison between the units. If I have explained so you don't understand my question, please let me know and I will try to explain better.
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.
2 Replies
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
