+ Reply to Thread
Results 1 to 2 of 2

How can I suppress a portion of a line graph?

  1. #1
    rshalayda
    Guest

    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.

  2. #2
    bj
    Guest

    RE: How can I suppress a portion of a line graph?

    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.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1