Rolling data table??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Data Table Label 3
Format Data Table 3
Eliminating "tails" on line charts 2
How do I keep excel chart "data table" formats in several workbook 1
Add vertical lines to a line chart (already has 2 Y axis) 3
Pivot Chart - X,Y & Data Series Options 4
Goal Line in chart but not on data tabel 1
Resizing a Line Chart 3

Back
Top