2 questions regarding graphs

[Guest]

Well, I really hope someone can help me out with this. Here are my questions..

(1) I have a graph with data that is based on cells with IF() formulae in them. I would like the blank response, "", to not show up on the graph. Unfortunately, I only know how to control displaying the points if the cells are actually empty, not if they simply show up as blank on the screen. Does anyone know a way to have non-empty blank cells not show up on a graph

(2) The same graph has a baseline value and a goal value. These are represented on the graph as horizontal lines. If I create these lines as a data series, it adds each series to the key. If I create these lines as Draw > Line lines, then they look (significantly) different when I zoom in or zoom out - something that will be necessary since this graph will be shown on a screen before a number of people

Thanks in advance for any help you can provide about this..
Dave Carl

 

[Frank Kabel]

Hi David
(1) try changing the IF formula as follows
=IF(condition,your_value,NA())
this create #NA entries for all missing values (you may use conditional
format to assign a white color for these entries to hide them)

(2) Maybe the following sites will help you to create some straight
lines
http://andypope.info/charts/averageline.htm
http://www.tushar-mehta.com/excel/charts/straight_lines/index.html
http://peltiertech.com/Excel/Charts/DummySeries.html#AddLine

 

[bill]

Question 1)
the NA() will leave a line between the outer points. if
you don't want the line to show, you can select the line
wait a short time and select the point on the line and
format it as no line for that section.
Question 2)
You can select the key reference and delte just the key
reference.