• 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

    Hui...

  • 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

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.


_____________________________________________________________

POST MOVED BY MODERATOR.

.
 
Last edited by a moderator:
Back
Top