Multi Line Graph (Planned and Actual) with Trend Line

Heather_Goetz_DAL

Hello I am looking for help in building a graph on a dashboard with multi lines (Planned and Actuals) tracking to a trend line and beyond. I have included an example below from Excel for reference. Any help you can provide would be appreciated.

Genevieve P.

Hi @Heather_Goetz_DAL

Here's how I would structure the Metric sheet:

As long as your Planned and Actuals are in separate columns, you'll be able to map them as lines across your dates, like so:

There currently isn't a way to add the vertical purple line in your graph to the chart, but you could add a third column with a value across two dates and then fill in that line:

Let me know if that makes sense and will work for you!

Cheers,

Genevieve

Heather_Goetz_DAL

Thank you soooo much. This is exactly what I needed.

messierr

How do you make the X axis in month day, YYYY ?

Is there a formula for you to point at a date column and change it from 3/4/2023 to March 4 2023?

Genevieve P.

Hi @messierr

In the images above, I just had the Date column formatted a specific way in the sheet and it translated into the graph as well:

See: Apply Standardized Date Formats in Your Sheet

Cheers,

Genevieve