With only a few chart types to choose from, we often have to get creative to achieve the desired results. In this case, a customer required an ability to view actual to target. I decided to use a technique for overlaying charts, but with a bit of a twist. Instead of showing actual vs target, I would create a dynamic popup that would show only the target for a bar that I have selected. Below is a quick rundown of what I did to each chart to get the shown result. The two most important parts for overlaid charts to work is that the X and Y Axis align perfectly, and the Y Axis max values are the same. If you look at both chart’s bindings you will see how easy it is to create this effect.

Download Source Files

Background Chart (Alerts Chart

General
Link data to data in column C

Behavior
Set manual scale and bind to C5

Drill Down
Enable Drilldown
Use Position and insert into C5
Drill down update behavior to on “Mouse Over”

Appearance>Layout
Hide Background
Hide Gridlines

Foreground Chart (Dynamic Plan Chart)

General
Link data to data in column E

Behavior
Set manual scale and bind to C5

Appearance>Series
Make the bar width to 5

Appearance>Layout
Hide Background
Hide Gridlines

All rights reserved Goodman Group LLC