I have a chart of two series, Sheet1!Foo and Sheet2!Foo. They are named in the chart the same way - Foo. How can I include the sheet name in the series name?

1 Answer 1


A chart is based on the data contained in the Data Range from which it is created, and nothing else. Sheet name is not a part of the picture. In order for sheet name to appear within the chart, it has to appear in the header row/column within chart's range. This can be done automatically by a script or a custom function, but with two sheets, it's far easier to rename the headers manually.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.