Conditional Formatting in same column with multi criteria

Kelly Gabel

That one is the Net Promoter Score, the Plan and Actual rows from January through the end of the year. In the chart, though, I only show the months, no quarter averages, etc.

Paul Newcome

Are you including the [Data Type] column when you select the data for the chart?

Kelly Gabel

No, but I can...and I see where you are going with that :) I will give that a try. Thanks!

Paul Newcome

Feel free to let me know if it works. If you look under the "Chart & Data" tab in the Chart Builder, you can use the "Select Columns" button to exclude those couple in between since you have to select a single range for the chart.

Kelly Gabel

Once again you rock :) Thanks @Paul Newcome !

Paul Newcome

Happy to help. 👍️