0

In Excel 2013, can the chart title and axis titles be read from cells in the spreadsheet? If so how?

| improve this question | | | | |
0

Follow the below steps to read Title and Axis tiles from a cell in the excel sheet.

On the chart, click on the 'Title' > click on the "Formula Bar" > enter '=' and select the cell from where you need to read the title and press 'Enter' key. Similarly for Axis titles, click on the Axis Title > click on the "Formula Bar" > enter '=' and select the cell from where you need to read the title and press 'Enter' key. Refer the screenshot.

Calculation is the Title of the chart. Month and Values are the Axis Titles.

enter image description here

Hope this helps.

| improve this answer | | | | |
  • Thank you. Got that now. I tried that before but I must have done something wrong. – Peter Lang Nov 29 '14 at 10:33

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.