Chart
Case Study – Creating a Dynamic Chart in Excel Using Offset Formula
detailed how-to create a dynamic excel graph and chart using excel offset functions and formulas
EXPLORE THE LIBRARY
Dynamic category
Chart
Incredible Excel 2012 Olympic Medal Count Dynamic and Interactive Dashboard
Excel Charts and Dynamic Dashboard for 2012 Summber Olympic Medal Count
Cell References
How-to Add Custom Labels that Dynamically Change in Excel Charts
How -to tutorial to make custom excel data that are dynamically linked to data points on a line chart for your company dashboard
Dashboard
How-to Format Trend Line Color in Excel Dynamically
Use a dynamic trend line to highlight dashboard trends in Excel templates with the use of color.
Axis Formating
How-to Show Decades and Highlight a Year in the Horizontal Axis
This is the dashboard tutorial that will show you how to only show the horizontal axis categories that you want to show and how to highlight a specific value
Chart
How-to Make an Excel Chart Title Change Dynamically
Easy way tomake a dynamic chart title in Excel Chart and Graph
Axis Formating
Using the Camera Tool to Create a Vertical Line Chart in Excel
Using the Camera Tool to Make a Dynamic Dashboard Vertical Line Chart in Excel
Chart
How-to Format Chart Axis for Thousands or Millions
Excel Dashboard Format Design for Millions or Thousands Chart Axis number categories
Bar Chart
Dashboard Design Examples – Excel Chart X-Axis Grouping
Sample chart design displaying Axis groupings for Excel Dashboards
Chart
How-to Hide a Zero Pie Chart Slice or Stacked Column Chart Section
Hiding Excel Pie Chart Slice when equal to 0 also how to hide stacked bar chart section using NA()