I am trying to create a graph for each store in my data sheet. I have a data sheet with a list of stores that lists the quantity that was ordered by each store for the month of December. Not all stores placed ordered on the same dates. What I would like to do is take the data from store line and create three columns that are : date, actual, target. When I copy the line and select paste special transpose the actual and target appear under each other. What I would like is to have them beside each other. It doesnt matter if the three columns include dates where the store did not order a quantity. (would be nice).
I have to do this for about 111 stores so I would like to find an easy way of doing this. reason for the three columns is because then I can create a graph a lot easier. I have included a sample sheet to help explain things easier. Thanks for any input. [url=http://uploading.com/files/3689748e/Book1%2Bsample%2Btest.xls/] Download Book1 sample test.xls for free on uploading.com[/url]
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
