Hi All,
I have a data set (attached file) I would like to create a chart that allows me to select different parameter and sample ID and display the result over time (for example select ammonium OUTFLOW results over time which need to be dates). I have used pivot chart but have the following problems:
1) It does not let me to select scatter chart type
2) when I select 'Add this data to the Data Model' pivot use count value and not supporting sum but if I don't select 'Add this data to the Data Model' it uses sum for value type but dates will be shown as year,quarters and months and not days.
Any idea how to fix the pivot or create a chart to simplify my data set?
Thanks
Bookmarks