Chart with moving range

[CarlosAndres]

Hi, I want to do a tendency chart using values that are added every day and I want to avoid changing ranges. The issue here is that I would like to have the option to show an specific range, in this case of dates and their respective values from the whole data base so the chart would show only those values, can be a range from the begining, from the middle or the end of the data base, no more no less......

Any help would be really appreciated......

Carlos

[DonkeyOte]

Not much to go on given you don't demo the desired result, however, have you considered / investigated using a Pivot Chart ?

(for intro. on subject of Pivots etc see link in sig.)

[CarlosAndres]

Thanks a lot.
Let´s put it in a diferent way, which actually can help me too, I´m trying to built a chart that doesn´t show #N/A cells, I did change the OPTIONS / AXIS / TIME SCALE and works but as the data has different values in a same day it put them all together in a vertical position. Then I did try changing the OPTIONS / AXIS / CATEGORY and it displays all the values well but includes the #N/A cells on the chart.
I´d like this chart showing just real values in a secuence way with it respective X-axis title.

Thanks..!

Carlos