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
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now