The chart from table shall count rows instead of summing up values that I have got in the titles

[Dirk Derichs]

I have got a table with 21 entries/rows. If i create a "chart from table" and enter the "title" for the "value columns" I receive currently 21.01, because one row title says "Example 01.01". If i change the 01.01 to 02.00 the chart say I have got 22 values as the chart is summing up the title values instead of counting the rows.

How can I get the row count instead of summing up the values in my titles?

Example table

Count | Title | Status

1 | John Doe 01.00 | Open

2 | John Doe 01.01 | Open

3 | Jane Doe 01.00 | In Progress

4 | Jane Doe 02.00 | In Progress

Expected result: Open 2 | In Progress 2

Current result: Open 2.01 | In Progress 3

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Dirk Derichs,

Please use the following settings for your Chart from Table macro:

If you want to present your aggregated data in a tabular way, you may use the Pivot Table
macro:

Hope it helps your case.