Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Chart needs to delete future values and axis

  1. #1
    New Member
    Join Date
    Jan 2016
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Chart needs to delete future values and axis

    Hi all,I'm trying to plot a regular line chart for every week this year with sales numbers, that are being extracted from a different sheet.Normally it plots 52 weeks, but since its week 4 now there are 48 empty points on the horizontal axis.I need these to be removed. So not only to I need to data points to be removed (I am aware of the NA() and customizing the format of the cell) but I need those axis to be removed as well so that it only shows week 1 to 4 and its actually a decent looking chart, and not one where 4 weeks of data are pushed to fit within 1cm and then 48 empty weeks on the x-axis. Next week, it will extract new sales information and it will automatically include week 5 in the line chart when it is week 5(I intend to do this using =today() and =weeknum(today()). Any help is much appreciated.Cheers,Jasper

  2. #2
    Board Regular DILIPandey's Avatar
    Join Date
    Jul 2013
    Location
    Dubai
    Posts
    1,336
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Chart needs to delete future values and axis

    Hi Jasperverdam,

    You can use dynamic defined names as a range in your chart.
    Suggest you to check internet about Excel: Dynamic Defined Names.

    Regards,
    DILIPandey

  3. #3
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,548
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Chart needs to delete future values and axis

    Last edited by Jon Peltier; Jan 21st, 2016 at 12:06 PM.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

  4. #4
    Board Regular DILIPandey's Avatar
    Join Date
    Jul 2013
    Location
    Dubai
    Posts
    1,336
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Chart needs to delete future values and axis

    Thanks Jon


    Regards,
    DILIPandey

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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