Chart data range
Hi All
I've got a Excel file with 12 speadsheets, one for each month. Lets just
deal with January, the cells i'm dealing with are E6,
F6,G6,J6,K6,L6,M6,N6,G12,H12, I12,J12,K12,N12,E18,F18,G18,H18,K18,L18.
I'm trying to make a line chart but because i just want to use these cells
when i try to enter the data range it just uses the K18 and L18, i know its
gonna be so darn simple or impossible lol
Hope you wiz people can help.
John
|