software

I have a spreadsheet containing orders per month for 2004, 2005 and 2006,
i.e. to date it has 25 values in it (up to and including Jan 06).

I want to create a graph that displays the last 12 months data
automatically, i.e. when the sales manager inputs feb 06 data, the graph then
changes from displaying jan05-jan06 to feb05-feb06 data.

I realise that my issue probably isn't the graph, but creating a table that
recognises when a cell changes from blank (or zero if necessary), then the
twelve month data has moved down a cell.

Hope this makes sense - please help!

Familiar post, I'll give a familiar answer.

peltiertech.com/Excel/Charts/DynamicLast12.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

quot;ajamesquot; (donotspam)gt; wrote in message
...
gt;I have a spreadsheet containing orders per month for 2004, 2005 and 2006,
gt; i.e. to date it has 25 values in it (up to and including Jan 06).
gt;
gt; I want to create a graph that displays the last 12 months data
gt; automatically, i.e. when the sales manager inputs feb 06 data, the graph
gt; then
gt; changes from displaying jan05-jan06 to feb05-feb06 data.
gt;
gt; I realise that my issue probably isn't the graph, but creating a table
gt; that
gt; recognises when a cell changes from blank (or zero if necessary), then the
gt; twelve month data has moved down a cell.
gt;
gt; Hope this makes sense - please help!
Absolute star! Thanks

quot;Jon Peltierquot; wrote:

gt; Familiar post, I'll give a familiar answer.
gt;
gt; peltiertech.com/Excel/Charts/DynamicLast12.html
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;ajamesquot; (donotspam)gt; wrote in message
gt; ...
gt; gt;I have a spreadsheet containing orders per month for 2004, 2005 and 2006,
gt; gt; i.e. to date it has 25 values in it (up to and including Jan 06).
gt; gt;
gt; gt; I want to create a graph that displays the last 12 months data
gt; gt; automatically, i.e. when the sales manager inputs feb 06 data, the graph
gt; gt; then
gt; gt; changes from displaying jan05-jan06 to feb05-feb06 data.
gt; gt;
gt; gt; I realise that my issue probably isn't the graph, but creating a table
gt; gt; that
gt; gt; recognises when a cell changes from blank (or zero if necessary), then the
gt; gt; twelve month data has moved down a cell.
gt; gt;
gt; gt; Hope this makes sense - please help!
gt;
gt;
gt;