I am trying to make a dynamic chart so that future zero values (months with no data yet) do not show up on the chart.
With my spreadsheet, I have the values for the chart being referenced from other cells. Having several months that have zero values (which cannot be deleted), how can I have a dynamic chart to not display the zero values?
The dynamic charts work (from my understanding) if the zero values are actually BLANK values.
Using =NA# causes the same issue and has the extra months plotted which I don't want. Is there a way to make a cell that is equal to a zero value in another cell be blank/empty?
I've been working on this for hours and cannot find a solution.
I followed the steps from this thread: http://www.excelforum.com/excel-charting/470385-charting-a-full-year-without-zeros.html
Last edited by kasimagj; 05-28-2008 at 04:46 PM.
You can use the COUNTIF function in your defined name instead of the typical COUNTA. See attached. For the values, I usedand for the monthsCode:=OFFSET(Sheet1!$B$3,0,0,COUNTIF(Sheet1!$B$3:$B$14,">0"))This will not work if you have 0 values for any past months.Code:=OFFSET(Values,0,-1)
ChemistB
Yay!
You're my savior!! Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks