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

Rick S.

Paul McGuinness

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

@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

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