Hi Guys
I have a very frustrating problem and I hope someone can help me out here...
1. I have a table with various columns that display currency values.
2. The table displays the currency of a selected cell A1(Euro, Pound etc.)... I have been able to get the Table to change to the currency selected by using (Conditional Formatting/New Rule/"Use a Formula to Determine which Cells to Format") and this works very well ie. the cells in the table change currency depending on the value of Cell A1....
My problem is...
- When I create a Chart using the Table in question... the Axis and Data Labels do not display the currency symbol of the data as reflected in the Table....???
It worked fine when I simply had the cells formatted for US$'s (as an eg.).... but now... nada....
Any ideas??
Thanx
MikeT
I have a very frustrating problem and I hope someone can help me out here...
1. I have a table with various columns that display currency values.
2. The table displays the currency of a selected cell A1(Euro, Pound etc.)... I have been able to get the Table to change to the currency selected by using (Conditional Formatting/New Rule/"Use a Formula to Determine which Cells to Format") and this works very well ie. the cells in the table change currency depending on the value of Cell A1....
My problem is...
- When I create a Chart using the Table in question... the Axis and Data Labels do not display the currency symbol of the data as reflected in the Table....???
It worked fine when I simply had the cells formatted for US$'s (as an eg.).... but now... nada....
Any ideas??
Thanx
MikeT