Forum Discussion
How to show comments/annotations on chart?
Hi abeiswinger,
Have you tried the solution provided by TomMartens above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here. :smileyhappy:
Regards
Hey,
you can create a calculated column that "pulls" the comment from your separate "comment" table into the table that provides the xaxis for your bar chart.
After doing this, you can drag the column to the tooltip bucket of your barchart and the comment will appear in the "annotation bubble".
If you need further assistance by creating the calculation it would be helpful, if you would describe your table structure and maybe you could also provide sample data.
Hope this helps
Hi Tom, thanks for your reply - I'm not sure how to create a calculated column to pull the data from the column table.
The datasource is an excel spreadsheet that looks similar to this:
Column A = City
Column B = Month
Column C = Department
Column D = Planned budget
Column E= Actual budget
Column F = Difference between planned vs. actual
Column G = Comments (why it was over/under budget)
Hey,
please provide a link to an excel file on onedrive or sharepoint, that contains your sample data.
Regards
I am facing same issue, can you please explain calculated column with an example
