Forum Discussion

Melissa Zabadal's avatar
Melissa Zabadal
Copper Contributor
Jan 18, 2018

Excel Graph > New Sheet Issue

I'm using this template:

 

https://templates.office.com/en-us/Weight-loss-tracker-TM03458079

 

I'm trying to make a copy of the original sheet, into the same workbook so I can track multiple people's weight loss (doing a weight war at work). Each time I do, the new graph does not seem to work. I can log the information, but it won't correlate to the graph. If you download the graph, you may have the same issue to understand what I mean.

 

Can someone help me with this issue? I am not good with coding or formulas, and am relatively new to excel so simplifying your answers would be appreciated. Thank you in advance! :)

 

 

PS: This was originally posted in Microsoft Answers but I was directed here by a Microsoft employee.

Charting
excel
  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Jan 19, 2018
    Hi Melissa

    I'm just running out the office for the week but had a glance at your question and from the look of the way the spreadsheet was done, it has hard coded things with Name range.

    Essentially when you copy the sheet and make a new one, it is always referencing the first one so it'll cause havoc.

    I don't have an immediate answer for you but if I get time in the new few days I'll see what I can do.

    Some of the other folks on the forum might have a way to fix the issue.

    Good luck and hafve a great weekend!

    Cheers
    Damien

Resources