Crash In Chart When Filtering Date

Crash In Chart When Filtering Date. Configuring a filter is as easy as setting its properties. So in summary filtering the data directly is good way to filter out a large amount unsummarized data.

In the Metric section click Add metric. Note that filtering data this way has no affect on the source data it only affects the data visible in the chart. Alt F1 if you want the chart on the same worksheet F11 if you want the chart on a new worksheet.

When drag and drop the date field as the first-row label you can filter date range in the pivot table easily.

This technique is much simpler than dynamic charts using drop-down lists and INDEX formula idea presented earlier. This issue is fixed in the latest Monthly Channel Version update. A fly out menu opens and as you hover over items with your mouse Excel will highlight each item in the chart. You can follow the question or vote as helpful but you cannot reply to this thread.