Dynamic x-axis with dates

[01mercy]

Hi all,

I am making a overview of excel graphs for our production quality measurements. This overview should be a first basic monitoring of our quality results.

What I want to make is a graph with on the y-axis the result and on the x-axis the date. The date range should be 2weeks before "today" and automatically adjust the range by each day passing by.

What I tried to do but what didn't work, is making the cell code in the range formula e.g. dat in C1:C200 depended on a formula CC(COUNT(C:C)-14):C(COUNT(C:C))
But that didn't work.

I've read something about an offset formula but I don't fully understand.


Thanks

 

[xlhelp]

Rather than re-invent the wheel, please look at Jon Peltier/Debra Dalgleish solution


Avoid Hangovers. Stay drunk.

 

[01mercy]

Thanks XLhelp, I found that solution also in "Excel charts" from John Walkenbach. Thanks