Currently, I have a Pivot table and chart that shows Filled Lines, Unfilled Lines and Partial Lines. I need to see Unfilled Lines as a percentage of all lines. In my pivot table, I right click my line count and go into Value Field Setting and change "Show Vales As" to "Percent of Row Total". This give me the percentages that I am looking for. However, I want a chart displaying only Unfilled Lines percentage.
I the attached workbook I have a pivot chart but I need it to only show unfilled lines. I have attempted to delete the 'Filled Lines' Line but it just changes the color.
I have an underlying SQL query that updates this every month so copy and pasting and creating another chart is not an option.
Bookmarks