Chart
How-to Insert Slicers into an Excel Pivot Table
In my last post, Think-like-a-database-designer-before-creating-an-excel-dashboard-chart we described the best way to configure your data to easily create your next dashboard. In this post,
EXPLORE THE LIBRARY
Tag: Table
Excel tutorial
How-to Add a Shape to a PowerPoint Table and Make it Move and Size with the Table Cell
As a project manager or business analyst, we are often called upon to create dashboard type views in status reports for Executives. Typically, company executives don’t want to see lots of wo
Copy
Copy Paste vs Fill Handle Copy with Tables References in an Excel formula
Facebook Twitter Pinterest WhatsApp Linkedin In this recent post: Friday Challenge Answers – Cumulative Events Over Time I created a formula that referenced a table. As I created my video I
Chart
How-to Make a Dynamic Excel Pie Chart with 4 steps in less than 4 minutes
This is an awesome guest post from our great friend Pete. He came up with this awesome technique to make a dynamic pie chart without the use of offset. THANKS PETE! Recently I saw some com
Chart
How-to Show Text in an Excel Chart Data Table (Part 1)
Learn 2 Excel Chart techniques on how you can create a more flexible Excel Chart Data Tables. One that shows how you can put in Text in the data table.
Chart Table
Friday Challenge Solution – Excel 2013 Data Labels on a Range
Friday Challenge Solution - Excel 2013 Data Labels on a Range
Challenge
Friday Challenge – Showing More Categories in an Excel Chart
Adding more Table Categories to your excel chart challenge
Gmail
How-to Create and Copy a Table in Google Mail (Gmail) from Excel
How-to make or copy a table into Google email without losing formatting from an Excel table. Tip & trick on how to make a table with borders in Gmail from Excel
Chart
How-to Add a Line to an Excel Chart Data Table and Not to the Excel Graph
how to video and step-by-step tutorial on creating more data table rows in an Excel Chart without adding more lines in the line chart.
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