SOLVED

Create a Chart from number of items per day

Occasional Contributor

I have a table that is updated daily depending on active projects. There are - on average-  10 new projects a day. I would like to create a chart that shows off the daily volume of new projects. 

 

Please see screenshot below. In column B, I am spilling the Received Date and in Column C, I am spilling a Yes or No associated with if we accepted the project.

 

It would be great to possibly create a Stacked Column Chart in which each value would be amount of projects each day, and the Column was split and showed how many were accepted and, on the other hand, how many were denied.

 

jwenzel_0-1654545248229.png

 

I appreciate your time.

 

Thanks! 

 

1 Reply
best response confirmed by jwenzCHUBB (Occasional Contributor)
Solution

@jwenzCHUBB 

You may create PivotChart based on PivotTable like

image.png