Forum Discussion
Offset Formulas
See How to Create a Dynamic Chart Range in Excel in particular the section "Using Excel formulas".
Please check Two top easiest ways to create a dynamic range in Excel chart (extendoffice.com) or google "excel dynamic charts" for other samples
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.
- 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.