Challenge
Change Chart from Amount to Percent using a Drop Down List
See how you can make a picklist or dropdown list change the number format of chart from an amount to a percentage.
EXPLORE THE LIBRARY
Pick List
Chart
Friday Challenge Submissions: Change Chart from Amount to Percent From a Picklist
2 different solutions to make a chart dynamically change from an amount to a percent in an Excel spreadsheet.
Challenge
Friday Challenge: Can the data in chart change itself to be percentages & number?
Can you use a drop down list to change a chart from an amount to a percentage? Is this possible?
Chart
How-to Create Dynamic Excel Dashboards Using Picklists
Let users pick the chart data displayed in your dynamic company dashboard by using a picklist that changes the values shown in your chart.
Chart
Creating Pick Lists in Excel for your Dynamic Dashboard
using data validation to make a dynamic chart for your excel company dashboard