Overlapping Two Charts

Sarah_KoSarah_Ko ✭✭✭✭✭
08/31/21
Answered - Pending Review

Hi all,

I have a column chart showing our actual hires and I was hoping to see if there is functionality to include a line graph on top of that to show the targets we had per month (see example below). If not, I'd be open to suggestions on the best way to display this.


Thanks!



Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    There isn't a way to do this yet. You would have to include either another set of bars in the same graph or make them both lines. Generally speaking, when I have a case like this where I want to show one as actual and the other as projected (or target) I will "fill in" the actual and leave the target as just a plain line.

    thinkspi.com

  • Sarah_KoSarah_Ko ✭✭✭✭✭

    Hi Paul,

    I like that idea, thank you for that clarification. I'll try to use your idea- and let you know if I have questions!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. 👍️

    thinkspi.com

Sign In or Register to comment.