Rolling data table??

B

Brandon

Does anyone know how to make a data table continually show the last part of
your data? I have about 3yrs of a data table for each month, and I am
wanting the chart and graph to show just the last 12mos each time I update
it. Is there a formula, rather than just adjusting the series values?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Consolidation Table from Different Excel Tabs with Different Format 1
Embed the same Excel multiple times 0
Excel 2007 charts: want to avoid zero values 1
Possible to Combine reports to's to a single box? 0
Cell data entering slow! 0
Adding data to MS Access from csv file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top