Fixed, data set was too large for the 10x10 area. Enlarged the area and it worked.
Anders. Thank you for the response. I reviewed the page to tagged in the response and determined that the issue could be resolved by limiting the n...
Anders. Figured it out. It was actually simple, horribly so, with the following IF in the target cell. B14 contains: =IF(Data!$E16="Analysis", I...
Anders, Yes I did review the workbook you sent. Our issue with that method is that our data comes from a tool and we have only a single entry per p...
Anders, Apologies for the horrible example, I realize I was looking at another Excel worksheet. So let's start from the beginning so that things mi...
Anders, Thanks for the response. Here is the flow of data for E5 and all other cells in the tblStoryTracking table. Day One: The Status say for ...
Fixed, pivot tables were set up incorrectly.
Mynda, No luck. I queried MicroSoft and the response was that if I had Windows 10 20H2 with a particular OS build that this problem could be duplic...
Mynda, Ok the data is good, I need no aggregation just the data for Open and Ideal provided in the stacked bar chart. The same data is shown i...
Mynda, So I am belaboring the point here I know but I am thinking that the data is not set up correctly. So that said I am sending a test workbook ...