Line Chart , Plot zero values as blank

Paddy1979

Well-known Member
Joined
Sep 23, 2005
Messages
608
Hello All,

Line Charts:

Is it possible to plot zero values as blank so there is no line on the chart for that value??

I tried if(a1=0,"",a1) but the graph still dispays a line across but with no series for that week with the zero sales.

Cheers
Paddy
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,114,052
Messages
5,545,735
Members
410,703
Latest member
yaronjoseph
Top