Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second...
A fan of the blog asked a question about this post:
Stop Excel From Overlapping the Columns When Moving a Data Series to the Second...
Friday Challenge Answers: Year over Year Chart Comparisons
Thanks for the submissions for the Friday Challenge.
You can get the sample data and chart request here: friday-challenge-help-new-to-excel-yoy-comparisons
Here are some other submissions:
A) In the...
How-to Create a Stacked and Unstacked Column Chart in Excel
Stacked and Unstacked Column Chart in Excel
Excel is awesome because, even when a certain chart type is not a standard option, there may be...
What to Do When Formulas Don’t Work from an Exported Salesforce.com Report or CSV...
Recently during a Project that was using Salesforce.com,
I created a custom report and then exported the results to Excel. This report looked and...
Is it Possible to make this Excel Column Chart?
I saw this seemingly simple question from an Excel user but I spent a long time trying to figure it out without much success.
Can...
Pipeline Usage Chart – Don’s Answer
Here is another response that I received from Don for our recent Friday Challenge:
Friday Pipeline Usage Challenge
Since we weren’t sure from the client if...
Friday Challenge – Advanced Excel Summation Skills
This is a fun skills challenge to make sure you are well rounded. What is the SUM of your Excel Game? You will find...
Find And Replace from a List of Multiple Emails in Excel without VBA
Find And Replace from a List of Multiple Emails in Excel without VBA
I had a recent request from a friend who needed to Find...
How-to Add a Line to an Excel Chart Data Table and Not to the...
Many people making Excel charts love to add a Chart Data Table to their graph. However, the Excel Data Tables are not very flexible...
How-To Create an Excel Step Chart Formula Using the Small Function
In our last Friday Challenge, we were investigating Step Charts. In case you missed it, you can check it out and download the sample...