Forum Discussion
Categorical vs. Continuous Time Axis in Charts
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.
- MojoGeneOct 31, 2023Copper Contributor
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:
- Riny_van_EekelenOct 31, 2023Platinum Contributor
MojoGene True. Can't help you then. Stick to PowerBI, I would say.
- MojoGeneOct 31, 2023Copper Contributor
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.