Hi,

You need to modify your formula to use NA() instead of zero.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Emma Chapman 123" wrote in
message ...
I have a spreadsheet set up that updates the information every month over a
12 month period. The data i have for example is
Actual Profile
Jan 77723 77723
Feb 75319 67582
Mar 72047 73469
Apr 69557 81048
May 76672 88563
Jun 65068 77750
Jul 63819 79528
Aug 71079 90357
Sep 65793 85348
0 0 0
0 0 0
0 0 0

Obviously i have not received the data for the last three months yet but i
need to keep the formulas in to automatically update the information. I
want
to select all of the information in this area but not show zeros on my
chart.
This chart will then update every month as the data updates. Is this
possible
to do. Please can someone help me.
Thanks