98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts and plotting nonzero amounts
Charts and plotting nonzero amounts
Resolved · High Priority · Version 2003
Tue 17 Mar 2009, 17:51Delegate Li-kim said...
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?
Thu 19 Mar 2009, 10:46Trainer Stephen said...
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
Thu 19 Mar 2009, 10:50Delegate Li-kim said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Line breaks in a cellYou can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it. |
