If you have plotted X1:X200, you could delete rows X1:X100 from the
worksheet and chart by selecting rows 1:100 and Edit|Delete (if
prompted, select entire row). Note that this will delete the entire
rows (not just column X), which may delete other items that you may not
be through with.

You could select just the cells X1:X100 and Edit|Delete|Shift Cells Up.

Note that deleting cells or rows may cause results to change if your
sheet contains live formulas.

Also note that while Excel will allow you to delete all cells in a chart
series, that action will not delete the chart series itself, which can
then be unpleasant.

Jerry

jrgarcia79 wrote:

Does any one know if it is possible to 'trim' data in the charts?
the idea is not only to 'hide' unwanted data but rather to actually delete
it in the chart and the dataset.

Perhaps is just not possible...

many thanks.