Stop Excel From Overlapping the Columns When Moving a Data Series to the Second...
Don’t worry, Excel is not changing your chart to a Stacked Clustered Column Chart or Stacked Bar Chart when you move a data series...
Excel Clustered Column Chart Conundrum
Many, many, many Excel users post this problem in user forums. And this one always throws me for a loop and takes me time...
How-to Make a Pass Fail Chart in Excel
Last week, I posed a Friday Challenge that was posted in a Q&A for Excel. Here it is:
*****************************************************************
Plotting a line graph to track build...
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...
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...
How-to Make Excel Put Years as the Chart Horizontal Axis Categories
I saw this post in a forum yesterday and thought that everyone should know this. Lord knows that I didn’t know this until just...
The Quickest Way to Select an Data Series in an Excel Chart
In a previous post, I showed you how to get around a frustration that many Excel users have when creating an Excel Dashboard chart. ...
How-to Make a WSJ Excel Pie Chart with Labels Both Inside and Outside
I thought it was a in last week’s USA Today, but looking at the picture I took more closely, it may have been produced...
Protecting Your Excel Charts and Dashboards with Array Formulas
Has this ever happened to you?
You have sent your Excel Dashboard to your executive team or perhaps you have your spreadsheet on a shared...
How-to Make a USA Today Pie Chart Graph – Replicating All Charts in USA...
I have been traveling very frequently for business as a Salesforce.com Software Consultant, so I spend a lot of time in hotel’s and airports. ...
