Hi All,

I need to know if it's possible to manipulate data before creating the chart?

e.g. I have a list with a single column of strings. I want to create a graph of this using all distinct entries for the x-axis and the count of that entry on the y axis.

I've not managed to find anything in the online docs or forum so far.

Any help greatly appreciated.

Cheer,

Olly

Hi Oliver,

Yes you can make this chart. Lets say you have the following list:

Country

USA
USA
China
Germany
China
USA
Germany
France
France

1. In the pivot page - drag and drop the Country field in the categories drop spot
(e.g. group by the Country field).

2. Set the category label to be the following expression:
=Fields!Country

3. In the pivot page - create a single Value (select the Values tab and click the Add button).

4. Enter the following expression in the Value field:
=Fields![RowCount]

You must see a chart with 4 bars. The category labels must be set to:
USA, China, Germany, France

The bar values must be:
3, 2, 2, 2

Hope this helps - questions or comments - please feel free...

Best Regards,
Nevron Support Team