Hi Experts,
Please find here attached sample workbook, where i want to change automatically Data Label & Vertical Axis format in chart based on the drop down selection.
I do have two Criteria 1) Hours and 2) Value for drop down selection. I have tried by applying conditional formatting as well for drop down selection. So if i do select Hours from the drop down then output will in Number format and if i do select Value then the output will in Currency format but it is also not displaying the required format.
Request to you please help me on the same.
Many thanks and regards,
Neilesh
Book2.xlsx
Bookmarks