I think it may just be an issue with the settings of your table calculations.
This may have been the method you already used, but I would suggest duplicating your table
to another sheet, and then moving the pills on that sheet around to create the graph.
In the table, the table calculation settings are Table Down, but that may not work when you
switch it to a graph. I would recommend setting the Compute Using to MONTH([(Date]).
Then from the table, I would:
- drag the Month([Date]) pill to the Detail shelf
- drag the Rank to the Detail shelf
- drag Exceedance to the Columns shelf
- drag Sum([Unique Value]) to the Rows shelf
I used that method in the workbook v10.3 attached in the Forum Thread.
If that is not similar to yours, please adjust it to match your calculations.
Better still, if you have the permission to do so, please post
a packaged workbook (twbx) Packaged workbooks: when, why, how
277785exceed.twbx 1.2 MB