Excel tutorial
Friday Challenge Answers – The Boss Says…
I received some great responses from lots of fans. Thank you so much for all your great comments. I agree with most and my solution was very similar to Peter R.’s below. BUT, as always, P
EXPLORE THE LIBRARY
Tag: 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.
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