Forum Discussion

Vicky405's avatar
Vicky405
Copper Contributor
Jan 19, 2022
Solved

Offset Formulas

I need to use an offset formula in the graph so when data is entered for Jan 22 through July 22 it will automatically update the graph.  Any formula ideas?   Series o
excel
HansVogelaar's avatar
HansVogelaar
MVP
Jan 19, 2022

Vicky405 

Column C will always have all values, so you should use the number of non-blank values in column F in the definition of the named ranges for both the x-values and the y-values.

Vicky405's avatar
Vicky405
Copper Contributor
Jan 20, 2022
I am still having issues. Can I send you the sheet and see if you can figure out a good formula? I have many other graphs I need to apply this formula to. d
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jan 20, 2022

    Vicky405 

    Do you see an area with "Drag and drop here or browse files to attach" below the box where you compose a reply? If so, add the workbook there.

    Otherwise: could you create a copy of the database, strip away everything that isn't relevant to the problem, as well as all sensitive information, then make the copy available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Post a link to the uploaded and shared file in a reply here.

    • Vicky405's avatar
      Vicky405
      Copper Contributor
      Jan 20, 2022
      See attached Excel File
      https://onedrive.live.com/?id=root&cid=2B8296FC37FC6CD7#id=root&cid=2B8296FC37FC6CD7
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Jan 20, 2022

        Vicky405 

        I fear that you haven't shared the file - I get a message that the item doesn't exist or isn't available anymore.

Resources