Creating Pie Chart from Conditional formatted data

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I don't see any dates with this data nor do I see categories. Is this just one week's data? And what is it that you want to see - is it a count of how many red, orange and green that you have?

First of all, I converted the data to an Excel table. Some of the advantages of excel tables are:

They "know" how big they are so formulas, charts and pivot tables build from them do not have to change as rows are added or deleted. These items will always reference exactly the right amount of data.

They "remember" and copy down formulas, validations, formats (including conditional formats) automatically. So you don't have to extend these items into unused rows or columns.

In the example you gave me, I added a helper column with the formula: =IF([@[Success %]]>=98,"Green",IF([@[Success %]]>=87,"Orange","Red"))

value less than 86% have a red background, those between 87 & 97% are orange, with those 98& and above green

You have gaps in your coverage. What value do you want to use for 86.5% or 97.5%? However, even if you always have whole numbers, the formula still works.

I built a pivot table from this table and a pie chart based on the pivot table and manually adjusted the data points to the appropriate colors. They should stay that way.

To use the workbook, highlight a column(s) of data in the table (rows 2 on down). Right click and select Delete -> Table Rows. If you see Delete -> Entire row, you have filtered the data. Take the filter off.

Then copy your new data and paste it into cell B2. The Excel table will do the rest, filling in the conditional formatting (I took the liberty of rewriting these too) and copying down the formula.

You may have to refresh the pivot table, Right click on it and select Refresh.