Combine charts in Smartsheet

Lindsay ✭✭
edited 12/09/19 in Smartsheet Basics

I would like add a chart to a dashboard showing actual vs forecast revenues per month.

I need a combined chart - actual revenue shown in bar format and forecast shown in line format.

I know you can do this type of chart in Excel however I'm struggling in Smartsheets I only have the option to have a line or bar chart.

Is there a way to do this or a work around please?

Thanks in advance