May 16 2023 03:01 PM
Hi All:
I would like to use the timeslicer to link multiple pivot charts. However, I found Excel's line plot will make the date in the x-axis not evenly distributed evenly. The gap when the machine not running is not reflected in the pivot chart (line plot with marker), Figure1, compare to the regular XY scatter plot, Figure2.
However, I didn't see the same problem when using Power BI, Figure 3.
Can anyone help to see if there is a way to make the Excel line plot in Pivotchart show all dates continuously and evenly distributed? Thank you.
Figure 1
Figure 2
Figure 3
May 16 2023 03:19 PM
Unfortunately, this is a (rather irritating) limitation of pivot charts with a date axis - it plots the values from the pivot field "as is".
(You may have noted that it is not possible to create an XY Scatter chart from a pivot table, so that is not a solution either).
Workaround: create your own (non-pivot) source table, using for example SUMIF/SUMIFS/COUNTIF/COUNTIFS formulas.
May 16 2023 03:26 PM