Here is where Excel pivot tables step in to extract data, which can help you avoid getting ... As mentioned, you can also create a custom pivot chart based on specific conditions.