Hello, If I have a bar chart how do i add a line denoting the goal upper and lower limit?

Answers

  • Paul McGuinness
    Paul McGuinness Overachievers

    Hi @Rick S.

    Unfortunately its not possible to mix two types of charts at present (Bar and Line for example), if you do want to show upper and lower limits around your data set then you would have to use a line graph and set the upper and lower limits as additional data points within the data.

    i.e.

    image.png

    which would give something like

    image.png

    Not the answer you were after but hope it helps

    Thanks

    Paul

  • Diane Moore
    Diane Moore โœญโœญโœญโœญ

    @Paul McGuinness - This suggestion was really helpful to me as I was searching for a way to report monthly numbers as progress over baseline towards a goal. Thanks for sharing.

  • Paul McGuinness
    Paul McGuinness Overachievers

    Hi @Diane Moore

    Glad it helped ๐Ÿ‘๏ธ, I still use the same format for progress against SLA targets on a lot of my dashboards.

    Thank you for the comment its great to know when things work.

    Paul