If you are using more than one chart and they share similar data, if the information changes in the shared data field, will both charts be updated?
If you are using more than one chart and they share similar data, if the information changes in the shared data field, will both charts be updated?
The chart should reflect the data it is linked to, assuming it is linked to cells or pivot table.
This would be very easy to test so I guess your question is not as straightforward as it first seems. If so you need to provide more information and preferably a sample file.
Like Andy has mentioned the questions is difficult to answer based on the information provided however, what I find most beneficial is to have a WS with all data and then just insert various pivot tables so you can have similar data but for separate charts.
You can then also insert slicers and connect various pivots and pivot charts together which allows you to select variables which then update whichever pivots and charts you wish.
Feel free to upload some data and an explanation of what you are trying to achieve and I'd be happy to help.
Hope this helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks