Peltier Tech Blog

Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | PTS Blog

 

Main menu:

 
Peltier Tech
Chart Add-Ins

Peltier Tech Waterfall Chart Utility
Peltier Tech Cluster-Stack Chart Utility
Peltier Tech Box and Whisker Chart Utility
Peltier Tech Marimekko Chart Utility
Peltier Tech Dot Plot Utility
Peltier Tech Cascade Chart Utility

 
Excel Dashboards

Subscribe

Site search

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Privacy Policy

Creative Commons License
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Overlapped Bar Chart – Thinner Bars in Front

by Jon Peltier
Friday, October 10th, 2008
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

In Overlapped Bar Chart – Longer Bars in Back I showed a fairly easy way to make a chart Robert Kosara developed to examine popular vote and Electoral College vote in US presidential elections. Stag Lee commented that Robert’s chart type was not intuitive, and suggested a slight modification, as shown here:

Column Chart Thinner in Front

This example uses the same data from the previous post.

Sample Data

Start with a simple clustered column chart.

Column Chart Thinner in Front

Select one of the series (in this case “One”), and move it to the secondary axis.

Column Chart Thinner in Front

Remove the secondary Y axis, the axis along the top edge of the chart.

Column Chart Thinner in Front

Change the gap width of the series in front to 200, and of the series behind to 50.

Column Chart Thinner in Front

This is also a relatively clear way to show the two series, but it’s not as striking when the thin series represents a larger value than the wide series. Robert’s chart, reproduced below, more clearly shows the series with the smaller value, because the smaller series bar is visible all the way to the left exis of the chart.

Column Chart Larger in Back

Related Posts:

Bookmark and share this entry:
  • Twitter
  • Digg
  • Facebook
  • LinkedIn
  • del.icio.us
  • Technorati
  • StumbleUpon
  • Google Bookmarks
  • Reddit
  • MySpace
  • Slashdot
  • Yahoo! Buzz
  • Tumblr

Learn how to create Excel dashboards.

Comments


Pingback from Excel Links of the Week – The Mt. Rainier edition | Pointy Haired Dilbert – Chandoo.org
Time: Monday, October 13, 2008, 1:54 pm

[...] Overlapped Bar Chart – Thinner Bars in Front: This extremely useful and neat charting tweak comes from none other than Peltier himself. Learn how to overlap bars in a bar chart such a way that thinner bars stay on top for that special occasion when you had to. [...]


Comment from Mrayo
Time: Friday, October 17, 2008, 10:42 pm

I am so gonna use this on my weekly report!
Thanks Mr. Peltier!
I always check your your site!


Comment from Anton
Time: Thursday, July 16, 2009, 5:58 pm

This type of chart is exactly what I was looking for to compare Target Sales to Actual Sales. The instructions are easy to follow and the results are great!

Well Done


Comment from Muzammil
Time: Monday, May 10, 2010, 5:36 am

Thanks for this tip, it’ll be very useful for me…

Write a comment

I welcome comments from my readers. If you have an opinion on this post, if you have a question or if there is anything to add, I want to hear from you. Whether you agree or disagree, please join the discussion.

If you want to include an image in your comment, post it on your own site or on one of the many free image sharing sites, and include a link in your comment. I'll download your image and insert the necessary html to display the image inline.

Read the PTS Blog Comment Policy.





Subscribe without commenting

Peltier Tech Waterfall Chart Utility Peltier Tech Cluster-Stack Chart Utility Peltier Tech Box and Whisker Chart Utility Peltier Tech Marimekko Chart Utility Peltier Tech Dot Plot Utility Peltier Tech Cascade Chart Utility

Create Excel dashboards quickly with Plug-N-Play reports.