Re: Zero data points

A few ways are:

- Plot by named ranges, which you can redefine to contain only the
amount of data you want plotted.

- Format the x-axis of the plot to show only the desired plot range

- Use #N/A instead of 0 to represent future values.

Jerry

Ian wrote:

> I have a datasheet with masses of data entered. I have
> created a graph that pulls from a totals line within the
> data sheet ranging from Jan 03 to Dec 03. I have set up a
> graph to pull the full years data in so as I do not have
> to keep changing the range of the graph. As my year
> figures are only up to June 03 the graph plots Jan - Jun
> 03 and then dips down to zero and across to Dec 03.
>
> I want my graph to show only the data points up to and
> including Jun 03 and progressively until the full year is
> complete with removing the formulas in the datasheet or
> having to edit the colour of the line in the graph.
>
> Help
>
> does anyone have any ideas. I will be so greatful,
>
> Thanks
>
> Ian