Jun 25 2020 03:41 AM
Jun 25 2020 07:55 AM
@Felix285 You can use a index column for it if you can provide a excel file for an example then I can explain you far better
Jun 25 2020 10:41 PM
Jun 26 2020 07:44 AM
SolutionLinear chart doesn't work with hours and minutes, day is the minimum unit. What is on X-axis of your chart that's text which can't be transformed, it is as it is.
In such cases Scatter chart is used, but PivotTable doesn't work with such charts. The workaround is to generate data by other way to use Scatter chart.
In your sample I added column with averages and sorted source range in ascending order. However, better solution will be to Power Query the source, aggregate within it and return ready to chart table.
Please check in attached file.
Jun 26 2020 08:33 AM
Please check this image I think this was what you needed. Also if you want the file do mail me I will give you the solution file on mail
Jun 26 2020 07:44 AM
SolutionLinear chart doesn't work with hours and minutes, day is the minimum unit. What is on X-axis of your chart that's text which can't be transformed, it is as it is.
In such cases Scatter chart is used, but PivotTable doesn't work with such charts. The workaround is to generate data by other way to use Scatter chart.
In your sample I added column with averages and sorted source range in ascending order. However, better solution will be to Power Query the source, aggregate within it and return ready to chart table.
Please check in attached file.