Nikanton
New Member
- Joined
- Nov 1, 2022
- Messages
- 1
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
Hello, I have a question on pivot charts. Let's say there is a pivot table with 3 columns. 1st:Issue name, 2nd
pened date, 3rd: closed date. The column with closed dates contains blank cells. I want to make a chart with 2 lines. X axis with dates and Y axis with number of issues. Each line would be the issues opened and issues closed.
I dragged the opened date to axis field and the same to values field in order to create the count opened dates. How can I also add the closed dates?
Thank you!

I dragged the opened date to axis field and the same to values field in order to create the count opened dates. How can I also add the closed dates?
Thank you!