Format a chart to automatically update with last 26 data points?

L

laf2day

I am trying to make a chart that will pull the most recent 26 weeks of data
automatically so I won't have to go in and change the range every single
week. I am adding the newest data to the right of the the existing data and
would like to have the chart just to the right of the most recent data.

If you have any suggestions please let me know.

Thanks!

David
 

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
Move Chart with Text 0
Chart SERIES OFFSET 5
Average bar charts with individual data points 2
Data points in chart incorrect 0
I need excel to only use the last 26 rows in a chart 2
Powerpoint for mac 2008 with Sierra OS, Red X instead of graph in all powerpoint files 0
source data needs to be updated weekly 4

Top