2

I have a link to a cell in a chart title so that it is dynamic. The cell contains a formatted number (1 decimal place). In the chart title it appears with multiple decimal places.

Example:

="Year average:" & A4

In the cell (A4) it will show a number e.g. 82.3 but in the chart title it appears as 82.2651431

Does anyone know how I can change this?

Improve this question
7
  • Please upload the excel file so we can take a better look. Also I think you can set it to a certain numbers after the decimal but I'm not sure since I don't have the excel file.
    – rrobben
    Commented Feb 28, 2017 at 12:02
  • Can't see a way to upload a sample of the file. It is sensitive information
    – colesc8
    Commented Feb 28, 2017 at 12:18
  • Maybe you could recreate the problem in a different excel file with no sensitive information. and then upload that one instead.
    – rrobben
    Commented Feb 28, 2017 at 12:19
  • Don't know how to upload the file to this site - can't see a link
    – colesc8
    Commented Feb 28, 2017 at 12:27
  • 1
    @RamonRobben: in general questions should be self containing with screenshots and sample data, sharing files is not preferred, please don't request for it.
    – Máté Juhász
    Commented Feb 28, 2017 at 12:54

1 Answer 1

Reset to default
3

Use the TEXT() function. Your cell's formula would be something like:

="Year average:" & text(A4,"0.0")

Format your number to taste-the formatting variable will accept any Excel Custom Formatting values (except color, I think).

Improve this answer
1
  • 1
    Yeah, it won't get the color in a custom number format.
    – Jon Peltier
    Commented Mar 2, 2017 at 2:48

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .