How can I suppress a portion of a line graph?
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. |
two ways
first is to delete the "0" values in the data series second is to click on the graph line wait a short time and click on the segnment you dont want and select just that segment. select none for line. there are other ways also "rshalayda" wrote: 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. |
All times are GMT +1. The time now is 05:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com