Hi,
I've put some dynamic graphs together without any problems. However... i'd like to only display results that are greater than 1.
I've attached a spreadsheet to illustrate. I have used named ranges.
In range "dynaValue2" I have replaced COUNTA with COUNTIF. But it does not seem to be working...
Anyone???
NB: I posted this yesterday but attached the wrong file. i deleted the other thread.
How about this, insert an extra column in your data table and refer to that in your chart. The #N/A will provide blank spaces in the chart for values below 1.
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
LOOKS GOOD. Cheers
Glad to help - thanks for the feedback
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks