Forum Discussion
Categorical vs. Continuous Time Axis in Charts
The default time axis for Excel charts is "categorical," where every value on the chart is evenly spaced from every other value as opposed to a "continuous" chart where the times are evenly spaced and the values show in related to when the results were actually created. This pivot chart demonstrates the problem. The values were created at random times, but appear evenly spaced on the categorical x-axis:
In Power BI, there is an easy solution to this, but I can find no way in Excel to switch between a categorical and a continuous time axis.
Thanks for any help
MojoGene Recognise the problem. As a workaround you can use a Scatter diagram with lines, rather than a regular line chart. A small example attached. Perhaps you can apply it to your own file.
Thanks for the reply. What you suggest works for a chart with one category, but there is large number of categories in my data set, which I believe makes a pivot chart the only practical solution. The scatter types charts cannot be used with data from a pivot table.
The date set looks like this:
MojoGene True. Can't help you then. Stick to PowerBI, I would say.
