A chart is a graphical representation of data that helps your audience to understand your information easily; charts make comparisons in your data and analyze the trends or patterns in data sets.
Follow the steps below to create a drop-down list using data validation in Excel. If you want to add a message pop up, you can click the Input Message tab and check the checkbox for “Show input ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results