MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Graph legends


Posted by Linda on August 07, 2001 9:58 AM

I am creating a graph from a pivot table and would like the legend to display two column fields (concatenated). Is there a way to do this? As I change the pivot table, I'd like the legend to change as well.


Posted by Jon on August 08, 2001 1:06 AM

If you set up a string, and name it "yourname" on the pivot table, or the initial figures sheet, you can then insert a TEXTBOX on the chart. Select the textbox and enter "=yourname"in the FORMULA Line (top of screen), NOT in the box itself. In Excel2000, the links are lost when the file is closed (see my earlier thread).

Hope this helps

BTW, if you really meant "legend" to refer to the labels, just change your data headings!