Charts, Dashboards and More – Best of Excel on the Web (May 2012)

In this article I’m going to do a quick round-up of the Best of Excel on the Web.

This last month has been pretty intense as I’ve been working on the launch of “Excel Power Tips”. The Ebook and Videos should come out next month (fingers crossed). In the mean time check out the teaser video and sign up for a 50% early-bird discount before it’s too late by heading over to the Power Tips page.

Just because I’ve been busy doesn’t mean there hasn’t been great Excel content published elsewhere on the web.

So here are some of my favorite posts, articles and videos that I found in the last couple of weeks.

Charts & Dashboards in Excel

These articles cover techniques and principles for creating charts and dashboards in Excel, with some useful ones that you may not have thought of yourself.

How to fine-tune the position of a chart from inside the VBA editor

How to show chart data when your data is hidden

Create a cool interactive Sales Chart

Create a Customer Service Dashboard in Excel

Conditional Formatting of Charts by Value and Label using VBA

Examples of Chart Junk from the Wall Street Journal

What to do for maximum impact when creating dashboards

More Excel goodies from around the web

Here’s a collection of tips and resources on formatting, pivot tables, userforms, VBA and migrating to Office 2010.

Find and replace specific colors (and when this does not work)

Excel Pivot Table Selection Quick Tip

Display text values in Pivot Tables without VBA

Disable autofit column widths for all Pivot Tables in a sheet (VBA)

Add New ComboBox Items in Excel UserForm

Move data from one sheet to multiple sheets using VBA

Upgrading to Office 2010? Download free Office 2010 migration guides

Finally here’s a link you should check out for fun!

Change the font in Excel column headers

Don’t lose the chance to secure your 50% discount on “Power Tips”

As I mentioned in the introduction, I’ve been working on the launch of “Excel Power Tips”. If you’d like to boost your productivity in Excel by learning tips & tricks, you should secure your 50% discount off the Ebook and Videos by joining the Launch Excel Early Bird List here.

About-Launch-ExcelWelcome to Launch Excel
If this is your first time to - Welcome to Launch Excel. My name is Victor and I'm the Chief Teaching Officer of Launch Excel, a website I started to help you learn how to use Microsoft Excel more effectively. Check out my welcome page created specially for you: Click here to view Welcome Page

10 Responses to Charts, Dashboards and More – Best of Excel on the Web (May 2012)
  1. Victor
    May 15, 2012 | 5:12 pm

    If you know of any Excel blogs or websites that published great material in the last couple of weeks but were not included in my list, I invite you to add a link in this comment section so that other Launch Excel readers will be able to benefit.


    P.S. Please only post Excel articles & resources here – any other links will be carefully reviewed and may be removed if found unsuitable.

  2. Ken Puls
    May 18, 2012 | 6:05 am

    Hi Victor,

    I have a couple that I’ve put up a my site that people may find useful:

    Highlight Subtotals For Easy Reading
    Retrieving Selections From A PivotTable Slicer



    • Victor
      May 18, 2012 | 8:29 am

      Hey Ken

      Thanks for posting those links.

      (1) Subtotals formatting tip – yep it’s funny that Excel’s subtotal feature doesn’t seem to automatically create the nice looking formatting that you show. One neat thing about SUBTOTAL is you get collapsing/expanding sections with the +/- buttons that appear on the left of the row labels.

      (For those with Excel 2010 you can activate the subtotal feature with ALT ➜ A ➜ B)

      (2) PivotTable Slicers – I like the interactive embedded Excel Web App spreadsheet in the section labelled “See it in action”.


  3. […] also has lots of useful links to other sites that have proven to be quite helpful. Overall the collection of information on his […]

  4. Steven
    October 21, 2012 | 12:25 am

    Victor is there a way you i can download your videos. the ones on Youtube are great but as you know you cannot really download them. so when i dont have internet connection i am stuck.

    • Victor
      November 7, 2012 | 6:39 am

      Hi Steven

      That’s a good point… at the moment there’s no simple way to download my videos from Youtube. I’ll see whether I can make them available as a download from my store, perhaps a 2012 Video Archive for download. If there are any particular videos you’d like to download, let me know by posting another comment.


      • Steven
        November 7, 2012 | 9:16 pm

        i would really like the entire video to watc cause it takes a longtime to watc online

  5. Victor
    December 10, 2012 | 2:21 pm

    Quick Update on video downloads – I made the Timeline Video and Template available as a paid download.

    And will add more videos to my shop as time allows. Of course the videos will remain watchable online too (via this site and also my Youtube channel).

  6. click here
    December 22, 2012 | 9:33 pm

    My spouse and I absolutely love your blog and find the majority of your post’s to be just what I’m looking for.
    can you offer guest writers to write content for yourself?
    I wouldn’t mind writing a post or elaborating on some of the subjects you write about here. Again, awesome web site!

  7. Patricia
    January 7, 2013 | 3:09 pm

    My brother recommended I might like this web site.

    He was entirely right. This post actually made my day.
    You can not imagine just how much time I had spent for this info!