I am trying to re-create some charts to track progress on my project. I want to be able to add data and for the charts to update themselves as more data is collected.
I have a picture of how the charts 'should' look from a previous exercise but i do not have the forumulas or pivot table know how to re-create for myself.
In my example, the All Data tab is updated with new rows each month. the next two tabs show a picture representation of what I would like to chart with the collected data (although the horizontal axis should show the month). The charts are to track volume and time (month).
Can you help?