
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.

See how you can make a picklist or dropdown list change the number format of chart from an amount to a percentage.

2 different solutions to make a chart dynamically change from an amount to a percent in an Excel spreadsheet.

Can you use a drop down list to change a chart from an amount to a percentage? Is this possible?

Friday challenge entry for the Top 250 Movies from IMDB in an Excel Dashboard

Excel Dashboard Template of Top 250 Movies on IMDB

In our last Friday Challenge, we presented a data set of the Top 250 Movies from IMDB and asked you to create a dashboard from that data set. Pete put together an amazing dashboard and here

How to make an Excel Dashboard from a list of the top 250 movies of all time.

How to make a stacked column chart with picture fill and custom axis numbers

See how Don created 3 different versions of charts for a recent Friday Challenge for SEO Performance bar chart, bubble chart and stacked column chart.

See how to create a hotel occupancy chart using advanced date functions, countif formulas and conditional formatting. Also included is finding out how many days are in any month and if any d