PowerPoint Ideas with Excel?

Hey Guys,

Trying to get some advice.

I work with a sales team and run POS Reports for them. I have been approached to take the data that I already have and instead of representing a revenue total sum the QTY. This is just a rundown of the project, but this part is obviously simple and done.

The team wants to see these numbers because of a PowerPoint presentation they create every month. It includes QTY by OEM (HP, IBM, Lenovo, etc..), Segment (server, notebook, and Desktop [one slide per segment with the data needed]), and a market share percentage. i Have all of this data in a pivot table (different worksheets for each segment).

I currently run market share for 2 out of the 5 accounts so not all of them.

I am curious on a couple of things:

1.) Is it easy to not necessarily create a static chart but a dynamic one that will, add a month and only keep a 12 month running graph (so it will delete the last month from the previous year), as well as continually update off of a refresh (button or something like this)

2.) Is it possible to create this chart and allow the end user to manually insert the Market Share percent, so they don't have to double click, find the source and change it?

I am attaching a sample graph. Please let me know if you have any questions!

Thanks,

Jeff