Why don't you create the chart with the data you have and then when there is
a new month to add simply highlight that data and either click and drag it
onto the chart or use copy and paste special to add the data
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


" wrote:

I am trying to create a chart of monthly percent gain across a given
year, and I have separated the data into two rows:

Jan Feb Mar Apr ........... Dec
#N/A #N/A 5% 12% .......... 0%

The #N/A signifies that there is no data for the given months, and the
0% signifies that the month is not completed. They are a result of the
formula being used to grab the data.

I'm not sure of what method is the best, but I simply want a chart
that only displays the months that contain a percent value (other than
0%). Any help would be greatly appreciated with this problem.

Thank you.
-bgetson