Jump to content

Data Labels in a Chart Excel 2003


Recommended Posts

Posted

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 B8

Event Timeline

=Info!$A$8&" "&Info!$B$8

output:

Event Timeline

which 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/2008

I've attached the file as well if you have questions regarding it.

Building_52_Projects.zip


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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...