excel - are you any good at it?
- Started
- Last post
- 7 Responses
- lowimpakt
I'm not but I know I want to create a spreadsheet that will allow me to input data into multiple worksheets and for that data to create one chart on a different sheet?
am i making sense?
- lowimpakt0
any tips on tutorials for his kind of thing?
- designbot0
They call me the master of the spreadsheets
I got 'em all laid out on my bed sheets
- lowimpakt0
are you asking me out?
- gramme0
I'm not any good at it, but if I was I sure as hell wouldn't tell anyone.
- lowimpakt0
i know what you mean. i'm trying to browse tutorials sites and i'm starting to feel ill
- jonturi0
this may work for you: just create the chart.xls. fill one sheet with the data references to all the other files with data and create the chart on second sheet of chart.xls using data from first sheet.
to do basic data reference to them just type "=" into a cell on chart.xls and then go to the other files and click the spots with data. the cell code will look like =[otherdata.xls]sheetName!$A$100
when you open chart.xls it may ask you to update data (if it was changed on the data files since the last time you opened chart.xls)
- Milan0
doesn't everyone put excel on their resume? even if they've only opened it once?