Forum Discussion
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
See How to Create a Dynamic Chart Range in Excel in particular the section "Using Excel formulas".
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
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.
- See attached Excel File
https://onedrive.live.com/?id=root&cid=2B8296FC37FC6CD7#id=root&cid=2B8296FC37FC6CD7I fear that you haven't shared the file - I get a message that the item doesn't exist or isn't available anymore.
- https://onedrive.live.com/?id=root&cid=109489C1C4368A02#id=root&cid=109489C1C4368A02