Hi,

I am having trouble getting my bar chart to update with the conditional formatting that is applied to the values. I was hoping that the "Linked to source" option would do this automatically for me, but the values are displayed as the original data format instead of the applied conditional formatting format.

I have a large workbook with currency values spread across the workbook.

I have a drop down that allows the user to select if they want the currency to be displayed as $ USD or € EUR. Based on that selection, the conditional formatting is set up to update the currency values throughout the workbook as $ or €.

I know that I can have the graphs update with the correct currency symbol by making the user format all the currency cells with the correct currency format, but I am really trying to avoid that. It is a lot easier for the user to be able to select the currency type and have the conditional formatting format all the currency values throughout the workbook to the correct currency format ($ or €).

Any help is greatly appreciated!

Thank you!!
Adam23