Data Series Name

[kghart]

I am trying to add wording in an Excel data series name, but also keep the
value linked to a cell in the spreadsheet. For example, the linked cell will
sum values from other cells. So, the data series name will equal that sum,
but in front of the summed value I would like to add the words "Total Sales".
Can this be done?

 

[Jon Peltier]

You have to construct the label in the worksheet cell, then link to it
in the series formula (or source data dialog).

For example, if the series name is in cell B1 and the value you want is
in C1, enter this formula in B1:

="Total Sales "&C1

Of course, to get the right formatting, you'll need to use the TEXT()
function:

="Total Sales "&TEXT(C1,"$#,##0.00")

- Jon