How-to Concatenate Excel Column or Row Data Using Google Docs
Yesterday I demonstrated how to find and replace a hard return in an Excel spreadsheet. I presented the last topic before this one so...
How-to Find and Replace a Hard Return in an Excel Spreadsheet
In a previous post, I showed you how to add a hard return within an Excel worksheet cell. You can check out that post...
Thanks for the Friday Chart Challenge Submissions – Vote in the Poll!
I had some AMAZING submissions for the last Friday Excel Chart Challenge.
Check out the post and file downloads here: Friday-excel-challenge-submissionswhich-chart-solution-one-do-you-like-best/
And don’t forget to vote...
Friday Excel Challenge Submissions–Which Chart Solution One Do You Like Best?
Sorry for the late posting. I was in Atlanta all week working on a new project and going out with the client at night,...
Dynamically Change Excel Bubble Chart Colors
In last week’s Challenge, I posted a question from an Excel User Forum that asked the following:
“I've used Excel 2010 to create a bubble...
Friday Challenge – Conditionally Control Excel Bubble Chart Colors
Hi All,
Sorry this is a little late. But better late then never .
Here is this week’s Friday Challenge (on Sunday. I will post my...
How-to Show Gaps in a Line Chart When Using the Excel NA() Function
In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart. In essence, he wanted to...
How-to Eliminate Statistical Outliers in an Excel Line Chart
Okay, I posted this Excel Chart Challenge on Friday. How did you do? I am sure your solution is better than mine. This was...
Friday Challenge – Eliminating outliers in and Excel Chart
Okay, apologies again . I have been so swamped with my Go-Live project this week that I have been too tired to finish the...
Friday Challenge Answer – Create a Percentage (%) and Value Label within 100% Stacked...
Last week I posted a Friday Excel Challenge!. Fun times. How did you do? Spoiler alert, if you don’t know how to create this...
