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
Dynamic category
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.
Connect Line Data Points
How-to Show Gaps in a Line Chart When Using the Excel NA() Function
Learn how to have gaps in a line chart when using the NA function in an Excel Formula
Chart
How-to Eliminate Statistical Outliers in an Excel Line Chart
Learn how to create a dynamic Excel chart where you can hide outliers in a Line chart or Line graph. Free Excel Template download file
Area Chart
How-to Make a Picklist Change the Chart Type for a Dynamic Excel Dashboard
How to use a pick list to change the chart type for your excel dashboard graph
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
Dynamic
How-to Create a Dynamic Excel Chart that Only Displays Non-Blank Values
How-to Create a Dynamic Excel Graph that Displays Only Non-Blank Values
Banding Horizontal
How-to Create a Dynamic Banding on an Excel Line Chart
Tutorial to make a confidence band in an Excel Line chart to shade a range to highlight thresholds in a Comany Dashboard Chart
Chart
Create a Dynamic Excel Pie Chart
Use the offset formula to create a dynamic pie chart or a dynamic pie graph in excel spreadsheets