1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic chart ( Number and %) need help

Discussion in 'Discuss Data Visualizations and Charting' started by wisecrack17, Jul 17, 2017.

  1. wisecrack17

    wisecrack17 New Member

    Hi Team,

    I would like to appreciate the support you guys provide. Here I am looking for a support in dyanmic charts.

    I have created a chart where I have a drop down to choose % and Numbers.
    problem is I have used a formula in a sheet where I have used if cell value is 1 then show data from set of cells where I have numbers and if cell value is 2 then show data from set of another cells in %.

    In both set of cell where I have the raw I have few cells with zero value. When I change it % to # then its not changing dynamically in the desired format.

    What should I do looking for your help.



    Last edited by a moderator: Jul 17, 2017
  2. Chihiro

    Chihiro Excel Ninja

    Please upload sample workbook that represent your set up (with desensitized data).

Share This Page