Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
chart with two data series and two colors for each data series | Charts and Charting in Excel | |||
2nd Axes - primary series data of only 1 series disappears! | Charts and Charting in Excel | |||
how do I plot a data series against two series | Charts and Charting in Excel | |||
Displaying single and multiple data series.Single data series | Charts and Charting in Excel | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel |