I want to create a line graph in Excel showing sales of three products. Two
of the products have 6 years of data, but the third has only been on the
market three years. How can I display only the last three years of data for
product 3 and eliminate the zeros that are assumed for years 1, 2 and 3? In
other words, I want to suppress the line segment that starts at zero in year
3 and rises steeply to the sales value in year 4 and show only the line
segments from years 4 to 5 and 5 to 6 for the third product.