How-to Mimic a Newspaper Chart Line Style in Excel
In the recent post: Friday Challenge – Mimic Newspaper Chart Line Style in Excel we wondered if it was possible to recreate this Chart...
Step-by-Step Tutorial: How-to: Make a Company and Industry P/E (Price to Earnings) Line Chart
In my last post I showed the concepts of making a P/E (Price-to-Earnings) Excel Chart for your Dashboard Template. In this post I will...
How-to Plot Building Wall UR Value in an Excel XY Scatter Chart
In an Excel Help Forum, an engineer wanted to know how to chart the following data:
The data would need to be plotted like on...
How-To Copy an Excel Chart on Same Worksheet with a New Data Reference
Many users in Excel spend time creating an awesome chart on a specific data set, then they want to use that chart on another...
How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset
Chart of Last 3 Months
If you wanted to create a dynamic Excel chart of last 3 months of your data but didn't know how to...
Create a Vertical Line Between Columns in Excel Using Error Bars
Create a Vertical Line Between Columns in Excel Using Error Bars
Thanks to Leonid (a super fan) for advising me on another and possibly better...
Friday Challenge – Analyzing Attendance Records with Six Sigma Charts
The following is a guest post from Pete on his answer to the most recent Friday Challenge.
Pete applied his knowledge of Six Sigma to...