Start and end date line chart

Finops C'ship

Hi Team,

Can anyone help me how can I create a line chart based on below information.

I

Christina09

Hi @Finops C'ship

Are you trying to create a line chart like this:

If so, you can create a helper column to combine start date and end date to a single cell. Then create a line chart like normal.

Finops C'ship

@Christina Lam

Yes..Can you please help me how to do it.

Regards,

Christina09

@Finops C'ship

I did it adding a helper column with this formula:

=[Start Date]@row + " - " + [End Date]@row

Then go to dashboard and select "+widget" -> "Chart" -> "add data" -> select the sheet -> highlight the data that needed to be in the line chart -> click "ok"

Under chart type, select "line" and you should end up having the same chart as below

Here is a link for more info on charts: https://help.smartsheet.com/learning-track/smartsheet-advanced/charts-dashboards