Excel Question

Akilae729

I have a template that I am pasting over 50 data sets into.

Each data set needs to go on its own sheet in the worksheet and is graphed using three graphs.

However, when i copy the template to a new sheet, the graphs still link to the data in the old sheet.

Is there a way to automatically have the graphs take their source data from the sheet they are on?

This will save me a shit load of time.

jimenex

Instead of copying and pasting the template into a new sheet, try copying the entire sheet by right-clicking the sheet tab on the bottom (there should be a 'move or copy sheet' option or something). I can't verify this to work yet, but if it doesn't just post it here and I'll check later for an alternative.

Crashtard

I would imagine that jimenex's solution should work, but it's hard to say without having a copy of the file to play with. I've never used Excel that way before, but as long as you have your graphs pointing to the data in the right cells copying the sheets should produce the result you want.

Akilae729

Just using the tab to copy didn't work

However, Taking the $ out of the source data lines and then using the tabs made it work.

This is a bullshit way to use Excel and if it wasn't required I could have done all of this in MATLAB in about half the time.

fml

Corvus

Akilae729 wrote: »

Just using the tab to copy didn't work

However, Taking the $ out of the source data lines and then using the tabs made it work.

This is a bullshit way to use Excel and if it wasn't required I could have done all of this in MATLAB in about half the time.

fml

Sounds like Excel was working exactly the way it was supposed to.