Hi, getting desperate here........
Imagine Cell A1 = Jan, Cell A2 = feb, Cell A3 = march...............Cell A13 = Jan.....Cell A25=Jan....Cell A37=Jan
Underneath each cell is a percentage value.
I need to be able to plot a bar chart just for January values, another for Feb values etc
I just can't find anthing that works. I have 300 instances of each month in the row (That's 3600 rows) so I can't imagine having to redo the whole thing with references to other cells etc.
Can I somehow create a seperate table for each month, without having to redo it all? My ideal solution would be to insert a formula and drag it whilst only copying every 12th row.
Thanks
Dantastic
Bookmarks