If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data Series Name
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? |
#2
|
|||
|
|||
Data Series Name
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 ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ kghart wrote: 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? |
Thread Tools | |
Display Modes | |
|
|