1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cumulative Line Chart Over Time Period

Discussion in 'Ask an Excel Question' started by Chets, Dec 4, 2018.

  1. Chets

    Chets New Member

    Messages:
    16
    Hi All

    I am trying to build a line chart that shows me cumulative total of planned vs actual servers over time. Attached sample spreadsheet shows rows of server names each with planned date and actual date. I would like to show for year/month the number of servers planned and actual cumulatively. The horizontal axis needs to be year/month and vertical axis should be number of servers.

    Chart should be similar to https://goo.gl/images/TXm8L3.

    Thanks.

    Attached Files:

  2. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,113
    I'd restructure your data. See attached.

    Use PivotTable to summarize your data, using Date without grouping (you may need to right click and ungroup) as Row label, and Count of Server Name as values.

    Then right click on value field and "Show Value As..." -> Running Total In.

    Base field set to Date.

    Attached Files:

    Chets and Thomas Kuriakose like this.
  3. Peter Bartholomew

    Peter Bartholomew Well-Known Member

    Messages:
    498
    Something like this?

    Attached Files:

    Chets likes this.
  4. Peter Bartholomew

    Peter Bartholomew Well-Known Member

    Messages:
    498
    This version is the same functionally as the previous #3 (if that is based upon a misunderstanding of what is required then so is this). What is different is that the calculation for the chart is done entirely within named formulae to bypass issues of extending or reducing array lengths (the helper ranges are no longer needed) as the data is changed.

    As a comment, this would have been so much easier if I had SEQUENCE, SORT and FILTER available to use. Can't wait!

    Attached Files:

    Chets likes this.

Share This Page