Show comparison of current selection Vs bookmark data on bar chart (user created bookmark in bookmark object on sheet)

[#1]

Hi,

I added a bookmark object onto the sheet so the user can add & delete bookmarks. But if there are multiple bookmarks added, how can I retrieve the name of the selected bookmark from the bookmark object dropdown list? Expression?

I need to write an expression in the bar chart inorder to display comparison for this selected bookmark Vs current selection in year listbox. What could be the expression? It should display 2 bars respectively.

I tried something like: =sum({Bookmarks}Values)

Here, 'Bookmarks' is the name of the bookmark object on sheet.

Any suggestions?

Thanks in advance.

[Anonymous]

Hi,

Please refer the following thread

How do I use an expression in a bookmark?

Hope it helps,I found this thread while searching for the bookmark and expression.

Thanks