+ Reply to Thread
Results 1 to 3 of 3

Labels "on top" og the graph does not dissapear when I delete datapoints along the x-axis

  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    14

    Labels "on top" og the graph does not dissapear when I delete datapoints along the x-axis

    I have a graph which have a y-axis which is dependent of a table i have made and the x-axis is dependent on a vector of dates.


    I have attached an example demonstrating my problem:

    TEST_GRAPHICAL REPRESENTATION.xlsx

    When I delete the latest or several of the latest dates in the yellow date-vector (because i do not want the graph to display data from these dates) the graph shortens as I want it to but the labels from the part of the graph which is now gone is located at the left of the graph!! How can i prevent this

    Thanks

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Labels "on top" og the graph does not dissapear when I delete datapoints along the x-a

    Hello,

    that is a very unfortunate data layout for any chart. Try to build a data table where you can select a series as one contiguous range, rather than having to select two ranges in two different columns. That is the cause of the confusion.

    For charting purposes, build a table that has the products in rows, and the dates in the column headers. Then each data series will be a single, simple range within a row.

    That way you can easily define the time frame that you want to show in the chart.

    If you also want a table that illustrates to the reader the difference between last year and the current year, by all means, build this table as a report, but do not try to use that report structure as the source data for your chart.

    Keep it simple.

    You may need to duplicate some data, but you will save a lot of headache.

    cheers, teylyn

  3. #3
    Registered User
    Join Date
    05-13-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Labels "on top" og the graph does not dissapear when I delete datapoints along the x-a

    Quote Originally Posted by teylyn View Post
    Hello,

    that is a very unfortunate data layout for any chart. Try to build a data table where you can select a series as one contiguous range, rather than having to select two ranges in two different columns. That is the cause of the confusion.

    For charting purposes, build a table that has the products in rows, and the dates in the column headers. Then each data series will be a single, simple range within a row.

    That way you can easily define the time frame that you want to show in the chart.

    If you also want a table that illustrates to the reader the difference between last year and the current year, by all means, build this table as a report, but do not try to use that report structure as the source data for your chart.

    Keep it simple.

    You may need to duplicate some data, but you will save a lot of headache.

    cheers, teylyn
    Thanks a lot

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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