Help with Bar Charts or something better, to compare two year sales

[Ecel Dumbo]

Hello Dear Excel Friends,


Please help create a BAr Graph or something better, to give a good comparisson of 2011 vs 2012 sales for each customers.


Basically would like to get a bar graph, X axis- will have two bars side by side for comparing 2011 and 2012 for each Customer with amount on sales appearing on top of the bar

On the Y axis will be the Sales Value. IF there is something better to make it presentable, please do advise.


Please see attached file


http://speedy.sh/cd6mJ/Charting-Query-compare-2011-vs-2012.xls


Thanks

Excel Dumbo

 

[Ecel Dumbo]

Any help will be greatly appreciated. THanks

 

[maku]

Take a look at this and see if it is what you are looking for...tab Chart.


http://speedy.sh/Tw6wS/Charting-Query-compare-2011-vs-2012-with-chart.xls

 

[Ecel Dumbo]

THanks maku. This is exactly what I wanted. Appreciate your help greatly. Now I need to figure out how you did this

 

[maku]

I just made a pivot chart...actually two because your data fields aren't consistent. Then lined up the columns 2011 and 2012 and made the bar chart. You don't have to do pivot charts though, you could simply copy and paste the customers and the totals for 2011 and then make a column 2012 and copy and paste the values from 2012 individually to the correct customer next to the 2011 totals. then make the bar chart.

 

[Ecel Dumbo]

thanks a lot maku. Appreciate your help.