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

Options

Answers

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭
    Options

    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.

    which would give something like

    Not the answer you were after but hope it helps

    Thanks

    Paul

  • Diane Moore
    Diane Moore ✭✭✭✭
    Options

    @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 ✭✭✭✭✭✭
    Options

    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