Hiding part of graph lines

Jeff Bremer

New Member
Joined
Oct 23, 2006
Messages
2
We have graphs that display monthly data trends set-up to read formulas. Formulas for future periods equal zero. Is there a way to hide the line of the graph for each month with a value of zero?

Thanks, Jeff
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,114,093
Messages
5,545,919
Members
410,712
Latest member
jhgeorge
Top