software

I am trying to make a chart with two series--one showing turnout in
presidential years and the other in mid-term elections.

In the first column I put the year (1960, 1962, 1964). In the second column
I put voter turnout in presidential years (1960, 1964). In column three in
put voter turnout in mid-term elections (1962, 1966). I select all the data.
The problem is in presidential years the data goes from, for example, 60% in
1960 down to zero in 1962 before going back to 60% in 1964. I want the data
line to go directly from 1960 to 1964 without dropping to zero in between.
Can anybody tell me how to do this? Thanks

--
Max Daniel
If the cells for 1962 in presidential years are blank, select the chart,
choose Options from the Tools menu, and on the Chart tab, for Chart Empty
Cells As, choose Interpolated.

If the cells contain a formula that returns quot;quot; for the in between years,
which is not a blank, change quot;quot; to NA() in the formula. This puts an ugly
#N/A error in the cell (use conditional formatting to hide the error), but
it results in a line from the 1960 to the 1964 point.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;Max Danielquot; gt; wrote in message
...
gt;I am trying to make a chart with two series--one showing turnout in
gt;presidential years and the other in mid-term elections.
gt;
gt; In the first column I put the year (1960, 1962, 1964). In the second
gt; column I put voter turnout in presidential years (1960, 1964). In column
gt; three in put voter turnout in mid-term elections (1962, 1966). I select
gt; all the data. The problem is in presidential years the data goes from, for
gt; example, 60% in 1960 down to zero in 1962 before going back to 60% in
gt; 1964. I want the data line to go directly from 1960 to 1964 without
gt; dropping to zero in between. Can anybody tell me how to do this? Thanks
gt;
gt; --
gt; Max Daniel
gt;
Thanks. It worked, but I have one more problem. Column one is the year,
column two is presidential year turnout, and column three is mid-term
turnout. When I select the chart and make a line chart, the X axis shows
numbers rather than years and list it as series one. How do I make it
category and show the years on the X axis?
Thanks very much for your help.

Max Danielquot;Jon Peltierquot; gt; wrote in message
...
gt; If the cells for 1962 in presidential years are blank, select the chart,
gt; choose Options from the Tools menu, and on the Chart tab, for Chart Empty
gt; Cells As, choose Interpolated.
gt;
gt; If the cells contain a formula that returns quot;quot; for the in between years,
gt; which is not a blank, change quot;quot; to NA() in the formula. This puts an ugly
gt; #N/A error in the cell (use conditional formatting to hide the error), but
gt; it results in a line from the 1960 to the 1964 point.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt;
gt; quot;Max Danielquot; gt; wrote in message
gt; ...
gt;gt;I am trying to make a chart with two series--one showing turnout in
gt;gt;presidential years and the other in mid-term elections.
gt;gt;
gt;gt; In the first column I put the year (1960, 1962, 1964). In the second
gt;gt; column I put voter turnout in presidential years (1960, 1964). In column
gt;gt; three in put voter turnout in mid-term elections (1962, 1966). I select
gt;gt; all the data. The problem is in presidential years the data goes from,
gt;gt; for example, 60% in 1960 down to zero in 1962 before going back to 60% in
gt;gt; 1964. I want the data line to go directly from 1960 to 1964 without
gt;gt; dropping to zero in between. Can anybody tell me how to do this? Thanks
gt;gt;
gt;gt; --
gt;gt; Max Daniel
gt;gt;
gt;
gt;
Right click on the chart, choose Source Data from the pop up menu. On the
Series tab, select the first series and delete it, then click in the input
box for Category (X Axis) Labels, and select the range containing the years.

In the future, set up the data so that each set of Y data has a column
heading, and skip the heading over the category values:

Pres Mid Term
1960 65% #N/A
1962 #N/A 55%
1964 60% #N/A
1966 #N/A 50%

The blank cell (and it must be blank, not quot;quot;) tells excel that the first row
and column are special.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;Max Danielquot; gt; wrote in message
news
gt; Thanks. It worked, but I have one more problem. Column one is the year,
gt; column two is presidential year turnout, and column three is mid-term
gt; turnout. When I select the chart and make a line chart, the X axis shows
gt; numbers rather than years and list it as series one. How do I make it
gt; category and show the years on the X axis?
gt; Thanks very much for your help.
gt;
gt; Max Daniel
gt;
gt;
gt; quot;Jon Peltierquot; gt; wrote in message
gt; ...
gt;gt; If the cells for 1962 in presidential years are blank, select the chart,
gt;gt; choose Options from the Tools menu, and on the Chart tab, for Chart Empty
gt;gt; Cells As, choose Interpolated.
gt;gt;
gt;gt; If the cells contain a formula that returns quot;quot; for the in between years,
gt;gt; which is not a blank, change quot;quot; to NA() in the formula. This puts an ugly
gt;gt; #N/A error in the cell (use conditional formatting to hide the error),
gt;gt; but it results in a line from the 1960 to the 1964 point.
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services
gt;gt; Tutorials and Custom Solutions
gt;gt; PeltierTech.com/
gt;gt; _______
gt;gt;
gt;gt;
gt;gt; quot;Max Danielquot; gt; wrote in message
gt;gt; ...
gt;gt;gt;I am trying to make a chart with two series--one showing turnout in
gt;gt;gt;presidential years and the other in mid-term elections.
gt;gt;gt;
gt;gt;gt; In the first column I put the year (1960, 1962, 1964). In the second
gt;gt;gt; column I put voter turnout in presidential years (1960, 1964). In column
gt;gt;gt; three in put voter turnout in mid-term elections (1962, 1966). I select
gt;gt;gt; all the data. The problem is in presidential years the data goes from,
gt;gt;gt; for example, 60% in 1960 down to zero in 1962 before going back to 60%
gt;gt;gt; in 1964. I want the data line to go directly from 1960 to 1964 without
gt;gt;gt; dropping to zero in between. Can anybody tell me how to do this? Thanks
gt;gt;gt;
gt;gt;gt; --
gt;gt;gt; Max Daniel
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
Jon,

You have been very helpful. Thank you.quot;Jon Peltierquot; gt; wrote in message
...
gt; Right click on the chart, choose Source Data from the pop up menu. On the
gt; Series tab, select the first series and delete it, then click in the input
gt; box for Category (X Axis) Labels, and select the range containing the
gt; years.
gt;
gt; In the future, set up the data so that each set of Y data has a column
gt; heading, and skip the heading over the category values:
gt;
gt; Pres Mid Term
gt; 1960 65% #N/A
gt; 1962 #N/A 55%
gt; 1964 60% #N/A
gt; 1966 #N/A 50%
gt;
gt; The blank cell (and it must be blank, not quot;quot;) tells excel that the first
gt; row and column are special.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt;
gt; quot;Max Danielquot; gt; wrote in message
gt; news
gt;gt; Thanks. It worked, but I have one more problem. Column one is the year,
gt;gt; column two is presidential year turnout, and column three is mid-term
gt;gt; turnout. When I select the chart and make a line chart, the X axis shows
gt;gt; numbers rather than years and list it as series one. How do I make it
gt;gt; category and show the years on the X axis?
gt;gt; Thanks very much for your help.
gt;gt;
gt;gt; Max Daniel
gt;gt;
gt;gt;
gt;gt; quot;Jon Peltierquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; If the cells for 1962 in presidential years are blank, select the chart,
gt;gt;gt; choose Options from the Tools menu, and on the Chart tab, for Chart
gt;gt;gt; Empty Cells As, choose Interpolated.
gt;gt;gt;
gt;gt;gt; If the cells contain a formula that returns quot;quot; for the in between years,
gt;gt;gt; which is not a blank, change quot;quot; to NA() in the formula. This puts an
gt;gt;gt; ugly #N/A error in the cell (use conditional formatting to hide the
gt;gt;gt; error), but it results in a line from the 1960 to the 1964 point.
gt;gt;gt;
gt;gt;gt; - Jon
gt;gt;gt; -------
gt;gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt;gt; Peltier Technical Services
gt;gt;gt; Tutorials and Custom Solutions
gt;gt;gt; PeltierTech.com/
gt;gt;gt; _______
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; quot;Max Danielquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt;I am trying to make a chart with two series--one showing turnout in
gt;gt;gt;gt;presidential years and the other in mid-term elections.
gt;gt;gt;gt;
gt;gt;gt;gt; In the first column I put the year (1960, 1962, 1964). In the second
gt;gt;gt;gt; column I put voter turnout in presidential years (1960, 1964). In
gt;gt;gt;gt; column three in put voter turnout in mid-term elections (1962, 1966). I
gt;gt;gt;gt; select all the data. The problem is in presidential years the data goes
gt;gt;gt;gt; from, for example, 60% in 1960 down to zero in 1962 before going back
gt;gt;gt;gt; to 60% in 1964. I want the data line to go directly from 1960 to 1964
gt;gt;gt;gt; without dropping to zero in between. Can anybody tell me how to do
gt;gt;gt;gt; this? Thanks
gt;gt;gt;gt;
gt;gt;gt;gt; --
gt;gt;gt;gt; Max Daniel
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;