Home Tags Grouping

Tag: Grouping

Grouping Pivot Table Data in Excel

Advanced Excel Summation Techniques Using Pivot Table

There are many ways to Sum data in Excel.  But when you have lots and lots of data, then you will want to learn...

How-to Graph Three Sets of Data Criteria in an Excel Clustered Column Chart

Here is a very simple solution to a common Excel Charting question when a user wants to graph “Three sets of data criteria on...

How-to Make an Excel PickList Chart for Multi Years by Month

Here is my response to the recent Friday Challenge on Creating a Chart for Multi Years by Month.You can read more about the original...

How-to Create an Excel Dashboard Column Chart with 2 Axis Groupings

Recently I saw this in the MrExcel Forums.  The title “Weird Charts with 3 Axis” intrigued me.I determined that they were looking to put...

Grouping Excel Column Charts with a Box

In a previous post, I showed you how to group a column chart with lines:You can check out the posting here: Group Column Chart...



How-to Make a Wall Street Journal Horizontal Panel Chart in Excel

In a recent Wall Street Journal article I saw the following chart regarding Dropbox, YouSendIt and Box.com.  The graph describes how many people use...

How-to Recreate a NYT InfoGraphic Mustache Grouping Chart in Excel

I love trying to create an Excel chart that was originally drawn with an Infographic software package.  Back in 2011 I saw a New York...

Sample Displays of Excel Chart Dashboard Designs using Axis Groupings

Dashboard Design Examples – Excel Chart X-Axis Grouping

When Designing an Excel Company Dashboard you will want to make sure that your audience can easily read and interpret the data.Which do you...

Group Column Chart with Lines for Excel Dashboard Presentations

Yesterday a user in the MrExcel.com Forums asked how he could make a Column Chart in Excel and then Group those Columns with a...

Popular Posts

How-to Easily Create a Stacked Clustered Column Chart in Excel

Create a Stacked Clustered Column Chart in Excel There is one type of chart that is always requested, however, Excel doesn’t offer this type of...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link