• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • FREE webinar: What does a post IR35 reform CV look like? : Wed, Jul 28, 2021 7:15 PM - 8:15 PM BST More details here.

Noddy Excel Help

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    Noddy Excel Help

    I have a spreadsheet which I fill in ever month to give me a monthly figure, I want this figure plotted in a basic line graph.

    However at the moment most of the monthly figures are blank as the months haven't happened yet so the graph has a couple of months worth of data and then flat line at 0 afterwards. I know I can change the range every month, but ideally I would to only include cells with a value in.

    Is this possible?
    Originally posted by Stevie Wonder Boy
    I can't see any way to do it can you please advise?

    I want my account deleted and all of my information removed, I want to invoke my right to be forgotten.

    #2
    Scrap that, found it by using na()
    Originally posted by Stevie Wonder Boy
    I can't see any way to do it can you please advise?

    I want my account deleted and all of my information removed, I want to invoke my right to be forgotten.

    Comment

    Working...
    X