Cell References
How-to Easily Paste a Defined Name in Chart Dialog Box
Using Function Key f3 in Excel to add Defined Names to Charts and Graphs
EXPLORE THE LIBRARY
/page/36/
Cell References
How-to Copy Charts and Change References to New Worksheet
How to copy an Excel Chart and Range and paste into a new worksheet, but change the chart series to reference a the new range.
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
Print Columns
How do I Print Repeating Rows or Columns for my Excel Report?
How to Print Excel Spreadsheet Print Titles for a Company Dashboard Template so that rows repeat on every page and columns repeat on every page
Cell References
How-to Make Excel STOP Selecting Range/Extending Range
While building your Excel Dashboard Templates, have you had the frustrating problem where Excel keeps highlighting a range of cells as you click on a new cell or change cells with the arrow
Formatting
Excel Line Break/Hard Return within a Cell
Most people don’t know that you can put a Hard Return (Line Break) within a cell because when they hit enter Excel takes them to a new cell. It is pretty simple to learn how to do this and
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()
Chart
How-to Make a Dynamic Chart Using Offset Formula
Offset function to make a dynamic chart for Excel dashboard templates