# Overlapping bars within chart

CParker
Guest
Posts: n/a

 30th Apr 2010
Sample scenario: Let's say in each year, I have this many cats:
2010: 6
2011: 8
2012: 20

Out of those cats, let's say that the following number have been neutered:
2010: 1
2011: 4
2012: 18

Is there a way for me to create a form of bar chart that shows the total
number of cats per year as a "background" bar, with the total number of
neutered cats in each year as a skinnier "foreground" bar that is a different
color and overlays the background bar?

CParker
Guest
Posts: n/a

 30th Apr 2010
I just figured this out on my own. As an FYI to anyone else, here was my
solution:
1. Plot the number of cats on the primary axis
2. Plot the number of neutered cats on the secondary axis
3. Format the "neutered cats" series to enlarge the gap width

"CParker" wrote:

> Sample scenario: Let's say in each year, I have this many cats:
> 2010: 6
> 2011: 8
> 2012: 20
>
> Out of those cats, let's say that the following number have been neutered:
> 2010: 1
> 2011: 4
> 2012: 18
>
> Is there a way for me to create a form of bar chart that shows the total
> number of cats per year as a "background" bar, with the total number of
> neutered cats in each year as a skinnier "foreground" bar that is a different
> color and overlays the background bar?

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post jim Microsoft Excel Charting 1 12th Aug 2009 03:35 PM Millie Microsoft Excel Charting 2 25th Apr 2009 04:16 AM =?Utf-8?B?SmF5?= Microsoft Excel Charting 1 11th Sep 2006 07:58 PM Graham Microsoft Excel Charting 1 27th Jul 2006 05:39 PM majikman Microsoft Excel Programming 0 10th May 2004 09:45 PM

Features