We are occasionally looking to design target vs actuals kpi’s for different processes
For example, we internally have a planned number of client implementations per month which we want to compare with the actual number of client implementations
Other examples of it’s use could be
- Target signups vs actuals
- Budget for revenue/expenses vs actuals
- Target for number of steps per month vs actuals
Using the Sheetgo dashboard it becomes super easy to visualize this using a bar and line chart combo - the bar remains in the background representing the target and the line in the foreground representing the actuals
A breakdown of the chart is below
Step 1: Setup the data on your sheet - for example we can do a simple row column format as shown below
Step 2: Use this data to create a bar line combo chart on the sheet - assign chart and series titles accordingly - this will render something like below
Step 3: Once the chart appears on the sheet you can add it to the Sheetgo dashboard - it will render something like below
Step 4: You can share the link to the dashboard with others to view the chart easily on different screen sizes
