Line Chart

 Line Charts are probably your go-to chart for displaying both actual and forecasted data in the same chart. They're particularly handy for comparing two future scenarios, but can be used for comparing your performance against a previous forecast or a budget.

Here is an example chart displaying company's cash balance. In this example, April books have been closed and thus the forecast starts from May. 

1. Select Add a Chart 

Start by selecting Add a Chart at the bottom of your company's dashboard page.

2. Name Your Chart

Give your chart a name and select Line as your Chart Type

3. Change the x-Axis Interval

Set the x-Axis interval to either Months, Quarters or Years

4. Select the Report Period

The Report Period defaults to a Custom Date Range. You can also select from one of the pre-built Report Periods such as Last Month, Year-To-Date, or This Year. These ranges are dynamic, meaning that the last month's values are going to change as you close your books for the month.

5. Add Lines

Click Add a Line button to begin selecting the accounts you want to display in your Line Chart. 

6. Select the Account

Select a desired account using the Account drop-down. Selecting the account will fill in the account name automatically, but you're able to edit it it under Name

7. Select a Snapshot and a Scenario

Select the desired scenario and a snapshot using the drop-downs. In this example we are going to leave the Snapshot drop-down as Current, meaning our line is going to represent the financial model's current forecast and not a previously set budget. 

8. Add More Lines (optional)

Repeat the steps #5-7 to add more lines to your Line Chart. Here's what adding an Aggressive scenario would look like. 

9. Save

You should see something like this. 

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us