Hello,
Not sure how to best explain this but here goes. I have a set of data with multiple measures (i.e. gross profit $, Product Cost $, Product Cost %, etc.). I am charting on this data but using a drop down to select which measure to chart on. That data then gets populated in specific cells in which the chart get's it's values. The data in these cells are formatted based on conditional formatting. For instance if I choose Gross Profit $ from the drop down, the cells will populate with the gross profit and be formatted as Accounting no decimals. However if I choose Product Cost % from the drop down the values change formatting to a % with two decimals. My goal here is to have the format on the chart's y axis change based on the cells formatting.
Attached is a sample file.
Your help is much appreciated!
Randy
Bookmarks