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 an...
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.
Riny_van_Eekelen I would normally have stuck with Power BI, but I had to develop something that could be used by non-organizational users. I tried exporting a live-data PowerPoint from Power BI, which is quite an elegant tool, but the non-organizational users couldn't tap into the live data on the PowerPoint either.