I have a simple table (
value) and I want to display that data in a chart.
This is my current chart:
As you can see, I don't have a value for each day, there is about one month between the last two dates. This makes my chart looks wrong, because it creates the same spaces between two dates, irrespectively of the date value.
If I create a new table with one row per day, I get the expected chart. But I need to create all that useless empty rows:
Is there a way to create a chart with a date-based x-axis? Can I create a chart that looks like the second one, but with the data from the first table?