Hi all,
I have a very basic table of data which is auto populated. I am trying to create a report on a seperate sheet which includes a very basic chart to visualise this, but I am struggling with it!
My table of data is as below:
I am trying to make it so that I can create a simple chart to show how many comments have been submitted for each department within the current month.
I have achieved the chart through a pivot table, but this isnt dynamic to adjust depending on which month we are currently in.
Does anybody have any idea if / how this can be achieved?
I have a very basic table of data which is auto populated. I am trying to create a report on a seperate sheet which includes a very basic chart to visualise this, but I am struggling with it!
My table of data is as below:
I am trying to make it so that I can create a simple chart to show how many comments have been submitted for each department within the current month.
I have achieved the chart through a pivot table, but this isnt dynamic to adjust depending on which month we are currently in.
Does anybody have any idea if / how this can be achieved?