If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Moving data for a chart
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! |
#2
|
|||
|
|||
Moving data for a chart
Chart the Last 12 Months
http://peltiertech.com/Excel/Charts/DynamicLast12.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "ajames" (donotspam) wrote in message ... 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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
mix chart types | Ken Murray | Powerpoint | 7 | April 28th, 2006 02:50 AM |
Dynamic XY scatter chart (map) w/ multiple data series in Access f | Allan L | Using Forms | 0 | February 11th, 2006 03:51 AM |
Help with data not getting plotted | Scott Ehrlich | General Discussion | 2 | January 25th, 2005 05:17 AM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |
Chart Data Table, Data Range, etc. do not update on Chart | RichardS | Charts and Charting | 3 | December 17th, 2003 05:56 PM |