+ Reply to Thread
Results 1 to 6 of 6

Display weekly data on a chart only if the week has a value

  1. #1
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    858

    Display weekly data on a chart only if the week has a value

    I am collecting weekly data but only want to show chart data for the weeks that have data. If I have 12 weeks but only have data for the first 6 weeks, I want to show only the 6 weeks on the chart, not 12 weeks with bars for the first 6. Is this possible? I would also like to add data labels above the bars but when I do the result is not what I expect? I have attached a sample file.
    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Display weekly data on a chart only if the week has a value

    How about...
    Attached Files Attached Files
    HTH
    Regards, Jeff

  3. #3
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    858

    Re: Display weekly data on a chart only if the week has a value

    Thank you very much Jeff. Works perfectly.

  4. #4
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    858

    Re: Display weekly data on a chart only if the week has a value

    Thanks Jeff, but I am trying to understand what you did to display only the bars that have values because it is not working on my real data and I am using the same formulas?

  5. #5
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    858

    Re: Display weekly data on a chart only if the week has a value

    Thanks Jeff. I found the Offset formula and now understand.

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Display weekly data on a chart only if the week has a value

    You are very welcome and glad it worked out for you. Thanks for the feedback and rep

+ 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