How-To

In the recent post: Friday Challenge – Mimic Newspaper Chart Line Style in Excel we wondered if it was possible to recreate this Chart...

In our last Friday Challenge, I proposed making a Double Lollipop Chart seen in the Wall Street Journal (WSJ).   Here is what our final chart...

You may not have known about Excel Chart Sheets.  About the only reason we can think of to use a chart sheet is if...

When I first learned to make Excel charts, I was taught to select the chart and then select the data series with my mouse. ...

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 Add Resource Names to Excel Gantt Chart Tasks I recently received a request from a fan that asked how he could add resource names...

Recently a user in the Mr. Excel Forum a member wanted to know how they could make an Excel Chart where one Metric was...

In a recent request for help in the MrExcel Forums, a user was having difficulties adding Vertical Line KPI Metrics to a Horizontal Bar...

Check out this simple technique if you have pressed the wrong keys on your keyboard and can't stop Excel from scrolling instead of moving...

Okay, the client is always requesting changes.  How do you deal with these?  I suggest increasing the contracted hours.  In this case, I decided...