Hello,
I need help please.
I created a bar chart on Sheet3.
I would like there to be a button on the ribbon that I can click that makes this chart popup in its own floating window/box just for viewing, allowing zoom in-out, panning, resizing of box, etc and it stays in place and in the front as you scroll and edit the current worksheet. It should stay open until I close it manually and it should update in real time if the chart on Sheet3 is updated by an edit I make elsewhere in the workbook.
I have seen solutions for text boxes to do this, but not charts.
Can anyone help with this please.
Thank you,
B
I need help please.
I created a bar chart on Sheet3.
I would like there to be a button on the ribbon that I can click that makes this chart popup in its own floating window/box just for viewing, allowing zoom in-out, panning, resizing of box, etc and it stays in place and in the front as you scroll and edit the current worksheet. It should stay open until I close it manually and it should update in real time if the chart on Sheet3 is updated by an edit I make elsewhere in the workbook.
I have seen solutions for text boxes to do this, but not charts.
Can anyone help with this please.
Thank you,
B