Chart x-axis scale

[blueback09]

I’m using the line chart to show values over time. The y-axis scales based on the relative sizes of the values, but the x-axis spaces dates at the same regular interval even if the time intervals between them are different.

Is there a way to scale the x-axis so that dates display at proportional distances apart?

[msamandadianne]

Would this help?

Chart Data Source with groupings and merged with

I’d like to make a line chart into a timeline that shows all the dates associated with a project. These dates are sourced from different data types which have the Project Name and Date fields (among others). For example, Expenses (Project Name, Date, Amount) and Income (Project Name, Date, Amount). There are two other data types that I want to include as well. Doing one data type for the data source works and it looks like this Data Source: Search for Expenses (constrain to project): groupe…