g_herm Posted January 25, 2008 Posted January 25, 2008 I am attempting to use 2 cell referances in a data label so that both cells show up in the label. I am attempting to use this formula A8 B8Event Timeline=Info!$A$8&" "&Info!$B$8output:Event Timelinewhich in a normal cell successfully mergers the info in to 1 cell.. however when I attempt to place the same formula in the data label an error occurs. Do data label on a chart not allow for formula?Also is there a way to format the two ref cells separately?I.E. I wish for my out put to look like this Birthday Party 7/18/2008I've attached the file as well if you have questions regarding it.Building_52_Projects.zip
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now