Sliding dates on a graph?

D

Dee Sperling

I have created stacked column graphs using the OFFSET function to
automatically update when each week's information is added to the worksheet.

However, now my boss want's only the last 4-6 weeks of information to be
displayed on the graph. Is there a way to do this without manually changing
each data point (there are 6 for each week for each chart--YIKES) every
week?

Thank you for your time,
Dee
 

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

Powerpoint for mac 2008 with Sierra OS, Red X instead of graph in all powerpoint files 0
My chart's X-axis isn't working properly 0
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Line graphs where data comes from formulas. 6
Creating a Chart on form from selected data in query. 0
Chart series select. 3
Excel 2007 charts: want to avoid zero values 1
Data points in chart incorrect 0

Top