SOLVED

Create a Chart from number of items per day

Copper 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 (Copper Contributor)
Solution

@jwenzCHUBB 

You may create PivotChart based on PivotTable like

image.png

1 best response

Accepted Solutions
best response confirmed by jwenzCHUBB (Copper Contributor)
Solution

@jwenzCHUBB 

You may create PivotChart based on PivotTable like

image.png

View solution in original post