Chart

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

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

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

I suggest an XY scatter chart rather than a line chart. Use the Month row
as your x-axis values in both series.

Dave
dvt at psu dot edu