Thread: Column Chart w/ Percentage and Text Data Lables

Is it possible for a column chart to display Data Labels in both Percentage and Text.

I have a table where I list services in column A, Purchased or not in column B, and the status in column C.

Column A: Entered Text
Column B: Text from drop down list
Column C: Formula =IF(B28="Yes",IF(B153=0,"No Findings",(B175/B153)),"Not Purchased")

So my table ends up looking like the following:

Column A Column B Column C
Service 1 Purchased 82%
Service 2 Not Purchased NP
Service 3 Purchased 61%
Service 4 Purchased No Issues
Service 5 Purchased 57%
etc.

In my column chart, Y = Percentage 0% - 100% and my X are the services listed in column A.

Using the example above, I want to be able to have the data labels in my column graph show EXACTLY what is in column C.

Currently my chart shows only percentages. So basically:
82% = 82%
NP = 0%
No Issues = 0%

I need to know what I have to do in order to show what is in Column C.

Any help will be greatly appreciated.

You can concatenate the values in the two columns into one and then use that column for the label. With the Chart Labeler Add-in, available here http://www.appspro.com/Utilities/ChartLabeler.htm you can specify just about any range in your spreadsheet as the source for the labels.

cheers