I have a data table which im trying to produce a some charts from but\ncant seem to get it right.\n\nbit hard to explain without seeing the table so I have provided the\ndummy workbook im working on at [URL="http://www.darkcity.nildram.co.uk/test.xls"]www.darkcity.nildram.co.uk/test.xls[/URL]\n\nin this example ive got the big data table, and the type of chart im\ntrying to produce form it us just below. the problem is ive had to\nmanually create another smaller table under the big one in order to get\nthe chart to look anything like what its meant to.\n\ni really need to have 3 charts produced based on whats in the big table\nif possible, I need charts by week, month and year in the same format\nas the chart ive made.\n\nalso in the chart i did manage to get which is just using total dummy\ndata, i need to put another 2 columns on the right hand end with\nanother axis on it for total actual and total plan which adds up the\nnumbers from the rest of the columns in the chart and displays the\ntotal for that period. I also cant work out why the legend is listing\neverything like that when all i want it to list is actual as one colour\nand planned as another (i clicked on the columns myself and changed\ntheir colours and suddenly the legend which did just say "week10"\nchanged to what it is now.\n\nWhat I need really is just some way to be able to generate these charts\nquickly without having to manually create these data tables because\ntheres going to be lots of data in the proper thing, at the moment its\njust one small thing from one of the project groups.\n\nalso the way the main data table is at the moment, the only way of\ntelling which project group each row belongs to is by the 'project'\ncolumns cell colour, for which i have put a key at the top, currently\nits just purple because they are all part of the 'special projects\ninfrastructure' group. for my sample table i just made up the data so\ni could demonstrate what the table should roughly look like.\n\nanyone help with this? seems very complicated to me, ive done a\n-little- bit of vb in excel with comand buttons and autofilter but not\ndone any charting and this seems to me not the easiest charts to make.