Bar chart with year on year sales but years are in one column

**johncassell** · 12-30-2010, 06:32 AM

Hi everyone,

Im struggling with this and not sure if its even possible..

I want a bar chart that show the customer along the bottom and sales value up the left hand side. I also want it to show year 2009 and 2010 alongside eachother in the actual graph. Problem is that the 2009 sales are in the same column as 2010 sales. Is there a way to do this please?

Customer Year Sales
JC Ltd 2009 100
BC Ltd 2009 200
IF Ltd 2009 300
JC Ltd 2010 544
BC Ltd 2010 220
IF Ltd 2010 112

Thanks,

John

**Andy Pope** · 12-30-2010, 06:52 AM

Ideally you would adjust the layout of the data for charting, with the year data side by side.

If not you can create the chart by selecting the 2 sets of data via the Source data dialog. See attached to see ranges used for each series.

**johncassell** · 12-30-2010, 07:20 AM

Hi Andy, thanks a lot for your reply. The charts you sent work but unfortunately I am dealing with a user who will re-sort his data in whatever order he feels like and then complain that the chart no longer works. So really I was hoping there was a way to have the chart look at the full column and put sales into one bar on the graph if the year is different. Don't suppose thats really possible?

John