Re: Chart

Sanj -

I suspect your series formula has the Pops data starting with the April
value, not the January blank. To make the chart from scratch, first
clear the cell that now says "Month". The blank helps Excel choose the
data range. Select the entire range, or a single cell within the range,
and run the chart wizard. Jan-Dec are the category axis labels, Age is
charted from Jan to Sep, and Pops from Apr to Dec.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Sanj wrote:
> Hello,
>
> I have a following chart problem:
>
> Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
> Age 10 20 30 40 50 60 40 50 30 N/A N/A N/A
> Pops 20 30 40 50 60 70 40 45 89
>
> How can I create linechart so that POps data starts
> showing beginning from Apr. I tried doing it but it always
> takes Pops data starting January. Any tips will be highly
> appreciated.Thanks
> Sanj
>
>