When I create a chart, I can click on the chart title in the Chart itself and put in a formula like =sheet!A3 (That will put the content of A3 as the Chart Title)
However, I can't seem to be able to combine formula like =sheet!A3&sheet!A4 -> This will give me the chart title and the MONTH.
Anyone has any experience in solving this one?
I'd suggest doing the combination in a cell and refer to that cell for your title.
not a professional, just trying to assist.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks