Dynamic chart and blank entries....wierd issue....anyone know whats going on
In another post someone helped me exclude "blanks".
when i use that formula in a defined name for plotting...........i am getting some really wierd results. i am enclosing a file for help explaining.
WHen you open the file do the following:
1) Change the named range "chrt_M_uat"
2) Next try to update the graph as follows:
click on one of the bars in the graph, then rt-click and goto select data. Then edit data for header1. Under teh series values change it from
when you try to do this you get formula error. Now open up name manager and edit name "chrt_M_uat"...............its no longer the same? its somehow changed
can anyone explain it?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1