1.PNG

2.PNG



Hi - Can you help me with the following?

I have a master data excel file from where I've created a data range using Pivot Table, slicers and INDEX and MATCH. Now this data range feeds into my charts. The user can now select certain filters and the chart will change automatically (as the underlying data range is changed with those selections). My master data has values in % and $.

QUESTION - 1) INDEX and MATCH doesn't return the source format My master data has values in % and $.. % values are pulled as "0.***" and $ values as "#####". Is there a way to restore the source format while using INDEX AND MATCH? This way I can use the Link to source options under Format Axis -> Number tab.

2) Can the chart axis be formatted automatically to % or $ based on the values in my data range. Please advice!!!