Li-kim has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
Charts and plotting nonzero amounts
I have a list in a protected/locked sheet where the formulas are used so that cells with the value of zero and other conditions show nothing ("").
E.g. IF(OR('start here'!$C$4<Overview!$A2,Overview!A2=""),"",Overview!A2)
When values are added to another sheet, the cells in this list automatically update and show values, depending on the formula.
Now, I want to plot two columns in that list on a chart (in the same sheet). When I highlight these columns the chart includes the "zero" values in the empty cells.
How can I make the chart not plot the empty/blank cells?
RE: Charts and plotting nonzero amounts
Hi Li-Kim
Thanks for question
This one is hard to comment on without seeing the workbook in question. If possible could you email me a copy at stephen@stl-training.co.uk and I will have a look for you and reply as soon as possible
Regards
Stephen
RE: Charts and plotting nonzero amounts
Hello Stephen,
Thanks for your help. I found a way out of this one.
EXCEL does not plot #N/A values so I had my zero/empty cells display that. That way, my graph did not show "zero values" of these cells. Then I applied conditional formatting where FORMULA = ISNA(--) so that cells with "#N/A" values were formatted as "invisible" (i.e. white font, white background).
Thanks
Li Kim
