2

I have a basic spreadsheet chart, which also includes a single labeled cell (set as a slider) that is used as a constant multiplier. (In this case, it is used to vary the number of workdays.)

I would like to use that value in the title of the chart: I.e.

"Salaries normalized to {NormDays} schooldays"

If there is no direct way, in the alternative what is the best way to display it floating on the chart on the chart in numeric form, possible with a label.... i.e.: Workdays: {NormDays}

Improve this question

1 Answer 1

Reset to default
1

As far as I can see, chart titles and labels (and text boxes) can't contain formulae. So I think this isn't possible in the ways that you suggest.

An alternative is to place a single-cell table on top of the chart, with the cell containing a formula like = "Salaries normalised to " & B1 & " school days".

Single-cell table table on top of chart

I'm using Numbers '09... hopefully this still works in later versions...

Improve this answer

You must log in to answer this question.

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