Hi, I have two charts one representing 2011 and one for 2012. They each have 4 columns representing countries and each column has 3 cost values (stacked). I want to show the columns for 2011 next to the columns for 2012 in one graph. I have them as 2 pivot tables at the moment.
2012.01_excel.pdf
I tried to attach an image (hope that worked).
Can anyone help?
Thanks,
You will need to combine the pivot table data into 1 and then the chart (if its a pivot chart) will get populated. You might need to make minor adjustments to the final chart to show it the way u want.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi, Thanks Arlette, I need to keep the stacking in each column. I can't work out how to manipulate the data to do that. Any tips?
thanks,
Jennifer
Your pdf attachment in the 1st post doesnt help much. Post a sample excel file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks