dynamic setting of data ranges

P

Patrick

I have a set of data, 1 x range and four y ranges, the data is end of week
totals,
i only want to see the last 13 weeks of data on a graph, how can i
dynamically set the data input ranges for each graph so that they only plot
the last 13 data points?????

the macro function doesnt seem to like relative references for the chart
data sections

thanks

pat
 

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

Dynamic stacked bar chart not working 3
max number of data ranges (bars) in a bar chart 5
Auto set data ranges 2
Dynamic chart ranges (slight variation) 2
Copying Named Ranges in Chart Series 1
problem with scatter diagram excel 2007 2
One Chart, Same Data ranges, different source sheets 4
Combining a 2-D column graph and a 2-D line graph on the same char 3

Top