Good Afternoon,
I'm trying to create a dual combination graph, but I'm having an issue. I've placed two fields (created and Closed date) in the columns, with the project ID in the rows portion. I'm hoping to create the bar graph portion with doing a count of all open status project IDs. any suggestions?
The kicker is I would prefer not to make modifications to the base data, as I have multiple graph's connected to it.
Attached is the workbook. Thanks for the help!
6 answers
I apologize for not being clear. I've attached an example I generated in Excel. I'm currently trying to reproduce the same graph found below: