In Excel it is indicated using the sheet name and the range in an absolute format. For example:
=Sheet1!$Q$15:$Q$18
It will be automatically picked up if you select your cells and then insert a chart. You can also enter them manually.
Chat with our AI personalities