If you want to impress your friends and colleagues, you can make an Excel chart change based on a drop-down box you have ...

One way to display figures in an Excel table according to certain time periods is by using filter buttons. However, a better ...

then click OK for both dialog boxes. You will notice that the May information that was missing is now shown in the chart. We hope you understand how to show charts with hidden data in Excel.

Let’s assume you made a chart in an Excel spreadsheet ... choose the data series name you want to change in the Legend Entries box, which appears on the left side of the window.