Currently it is not possible to used defined Named ranges within diagrams, e.g. for categories or Y-values and categories.
Using Named ranges within diagrams will bring much more flexibility in creating diagrams.
Steps to Reproduce:
Named ranges are not accepted when entering them into one of the fields in a diagram, like Y-values, categories.
Named ranges are accepted independently if a named ranges coveres an area or contains a formula.
User Profile Reset: No
*** Bug 132648 has been marked as a duplicate of this bug. ***
If "diagrams" are charts, this is a duplicate.
*** This bug has been marked as a duplicate of bug 66250 ***