# Trying to only compare one bar in a bar chart that has multiple months

1. ## Trying to only compare one bar in a bar chart that has multiple months

I have a bar chart that lists months and shows the percentage. I would like to compare the 1st quarter average from this year to last year. I do not want to compare the months individually, just the 1st quarter. Does that make sense? I have attached a picture where I have what I want to do separated into 2 charts. I want to take the bars from the 2nd chart and add it to the first without comparing anything to Jan, Feb, or March. Any help?
excel chart.png

2. ## Re: Trying to only compare one bar in a bar chart that has multiple months

Hello
Something like this?

Chart Example.jpg

3. ## Re: Trying to only compare one bar in a bar chart that has multiple months

Close. But is there any way to add Qtr 15 and Qtr 14 to the end? So it has Jan, Feb, Mar, and the Qtr15 and Qtr14 right next to each other?

Thanks for helping!

4. ## Re: Trying to only compare one bar in a bar chart that has multiple months

I'll work on it and get back if I come up with a solution.

5. ## Re: Trying to only compare one bar in a bar chart that has multiple months

Is this closer?

Chart Example 2.jpg

6. ## Re: Trying to only compare one bar in a bar chart that has multiple months

That is perfect!!!!!

How did you do that?

7. ## Re: Trying to only compare one bar in a bar chart that has multiple months

Hello
I've put a message in your other post which is a duplicate to this one. I'll upload a sample file and explain the above chart.

Regards
DBY

8. ## Re: Trying to only compare one bar in a bar chart that has multiple months

Hello
Here's the example chart. You need to use the data layout with some empty spaces so as to move the Qtrs to the end of the Axis. If you didn't need them pulled together, you could put them all on one axis but as you want the Month bars spaced I've put the Qtrs and Months on different Axis and series in order to format each differently.

DBY

9. ## Re: Trying to only compare one bar in a bar chart that has multiple months

Sorry about the duplicate. The other one quit showing up in my posts and I couldn't find it posted, so I reposted it. That was my fault.

Thank you so much for the help! I spent all day and just could not get it.

10. ## Re: Trying to only compare one bar in a bar chart that has multiple months

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1