CODEWITHSUNDEEP
excelgraph
Rise_against
Rise_against

Reputation: 1070

running total count in pivot chart

I am having troubles creating a pivot chart. This is how my pivot table currently looks:

Row Labels   |   Count of New Interfaces
apr/12       |   3
may/12       |   1
dec/12       |   2

I would like to create a graph that shows me the running total of interfaces during a period. I would like to see a line graph that has a horizontal axis for the months and a vertical axis for the total number of interfaces.

For example:

Does anyone have an idea how to configure the pivot graph?

Upvotes: 2

Views: 2213

Answers (1)

Tom Sharpe
Tom Sharpe

Reputation: 34315

Should that be 6 for December?

  1. In your pivot table, you go to Sigma values, where you should currently have Count of Interfaces.

  2. Go to Value Field Settings -> Show Values As tab -> Running Total In

  3. Select the variable that you are using as your row label (i.e. Months).

Then you can choose the type of Pivot Chart that you would like by clicking on the ribbon.

Screenshot

Upvotes: 3

Related Questions