software

I have a spreadsheet with a two columns, one for expected enrolment numbers
and the first column of actual enrolments. For April we expect 90, so have a
blank cell to the right for actual. This is showing a line from the March
enrolment of 3 down to 0. How do I get the line to stop at 3 until I put a
figure in for April?

Excel lets you choose how you can plot empty cells.

As zeros, not plotted or interpolated.

To make your choice, select your chart, go to Tools gt; Options gt; Charts and
select the Not Plotted option button for empty cells.

....Kellyquot;Sheila Innesquot; gt; wrote in message
...
gt;I have a spreadsheet with a two columns, one for expected enrolment numbers
gt; and the first column of actual enrolments. For April we expect 90, so
gt; have a
gt; blank cell to the right for actual. This is showing a line from the March
gt; enrolment of 3 down to 0. How do I get the line to stop at 3 until I put
gt; a
gt; figure in for April?
Thanks Kelly. Problem - the Not Plotted is grayed out, so I can't mark it.
Any ideas?

quot;Kelly O'Dayquot; wrote:

gt; Excel lets you choose how you can plot empty cells.
gt;
gt; As zeros, not plotted or interpolated.
gt;
gt; To make your choice, select your chart, go to Tools gt; Options gt; Charts and
gt; select the Not Plotted option button for empty cells.
gt;
gt; ....Kelly
gt;
gt;
gt;
gt;
gt;
gt; quot;Sheila Innesquot; gt; wrote in message
gt; ...
gt; gt;I have a spreadsheet with a two columns, one for expected enrolment numbers
gt; gt; and the first column of actual enrolments. For April we expect 90, so
gt; gt; have a
gt; gt; blank cell to the right for actual. This is showing a line from the March
gt; gt; enrolment of 3 down to 0. How do I get the line to stop at 3 until I put
gt; gt; a
gt; gt; figure in for April?
gt;
gt;
gt;

1. Select the chart before going to Tools - Options - Charts.
2. What kind of chart is it?
3. If it's a line or XY chart, if you have a formula that returns quot;quot;,
understand that this is not a blank cell, it's a cell with a formula, so
Kelly's solution won't change how the cell plots. Change the quot;quot; in the
formula to NA(), which gives you an ugly #N/A in the cell, but gives you the
Interpolate behavior in the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;Sheila Innesquot; gt; wrote in message
...
gt; Thanks Kelly. Problem - the Not Plotted is grayed out, so I can't mark
gt; it.
gt; Any ideas?
gt;
gt; quot;Kelly O'Dayquot; wrote:
gt;
gt;gt; Excel lets you choose how you can plot empty cells.
gt;gt;
gt;gt; As zeros, not plotted or interpolated.
gt;gt;
gt;gt; To make your choice, select your chart, go to Tools gt; Options gt; Charts
gt;gt; and
gt;gt; select the Not Plotted option button for empty cells.
gt;gt;
gt;gt; ....Kelly
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Sheila Innesquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a spreadsheet with a two columns, one for expected enrolment
gt;gt; gt;numbers
gt;gt; gt; and the first column of actual enrolments. For April we expect 90, so
gt;gt; gt; have a
gt;gt; gt; blank cell to the right for actual. This is showing a line from the
gt;gt; gt; March
gt;gt; gt; enrolment of 3 down to 0. How do I get the line to stop at 3 until I
gt;gt; gt; put
gt;gt; gt; a
gt;gt; gt; figure in for April?
gt;gt;
gt;gt;
gt;gt;
Hi Jon

I checked the chart and the 'not plotted' option is already selected. The
equation for the chart is =Recruitment!$B$4:$B$9,Recruitment!$O$4:$P$9.
The B selection is the month, the O is the actual and the P is the target.
Any more help much appreciated.

Regards
Sheilaquot;Jon Peltierquot; wrote:

gt; 1. Select the chart before going to Tools - Options - Charts.
gt; 2. What kind of chart is it?
gt; 3. If it's a line or XY chart, if you have a formula that returns quot;quot;,
gt; understand that this is not a blank cell, it's a cell with a formula, so
gt; Kelly's solution won't change how the cell plots. Change the quot;quot; in the
gt; formula to NA(), which gives you an ugly #N/A in the cell, but gives you the
gt; Interpolate behavior in the chart.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;Sheila Innesquot; gt; wrote in message
gt; ...
gt; gt; Thanks Kelly. Problem - the Not Plotted is grayed out, so I can't mark
gt; gt; it.
gt; gt; Any ideas?
gt; gt;
gt; gt; quot;Kelly O'Dayquot; wrote:
gt; gt;
gt; gt;gt; Excel lets you choose how you can plot empty cells.
gt; gt;gt;
gt; gt;gt; As zeros, not plotted or interpolated.
gt; gt;gt;
gt; gt;gt; To make your choice, select your chart, go to Tools gt; Options gt; Charts
gt; gt;gt; and
gt; gt;gt; select the Not Plotted option button for empty cells.
gt; gt;gt;
gt; gt;gt; ....Kelly
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Sheila Innesquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I have a spreadsheet with a two columns, one for expected enrolment
gt; gt;gt; gt;numbers
gt; gt;gt; gt; and the first column of actual enrolments. For April we expect 90, so
gt; gt;gt; gt; have a
gt; gt;gt; gt; blank cell to the right for actual. This is showing a line from the
gt; gt;gt; gt; March
gt; gt;gt; gt; enrolment of 3 down to 0. How do I get the line to stop at 3 until I
gt; gt;gt; gt; put
gt; gt;gt; gt; a
gt; gt;gt; gt; figure in for April?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Sheila -

Do you have formulas in Recruitment!$B$4:$B$9 and Recruitment!$O$4:$P$9?
This is where you need to change quot;quot; to NA(), if it's a line or XY chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;Sheila Innesquot; gt; wrote in message
...
gt; Hi Jon
gt;
gt; I checked the chart and the 'not plotted' option is already selected. The
gt; equation for the chart is =Recruitment!$B$4:$B$9,Recruitment!$O$4:$P$9.
gt; The B selection is the month, the O is the actual and the P is the target.
gt; Any more help much appreciated.
gt;
gt; Regards
gt; Sheila
gt;
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; 1. Select the chart before going to Tools - Options - Charts.
gt;gt; 2. What kind of chart is it?
gt;gt; 3. If it's a line or XY chart, if you have a formula that returns quot;quot;,
gt;gt; understand that this is not a blank cell, it's a cell with a formula, so
gt;gt; Kelly's solution won't change how the cell plots. Change the quot;quot; in the
gt;gt; formula to NA(), which gives you an ugly #N/A in the cell, but gives you
gt;gt; the
gt;gt; Interpolate behavior in the chart.
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt;gt; PeltierTech.com/
gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt;gt; _______
gt;gt;
gt;gt; quot;Sheila Innesquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Thanks Kelly. Problem - the Not Plotted is grayed out, so I can't mark
gt;gt; gt; it.
gt;gt; gt; Any ideas?
gt;gt; gt;
gt;gt; gt; quot;Kelly O'Dayquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Excel lets you choose how you can plot empty cells.
gt;gt; gt;gt;
gt;gt; gt;gt; As zeros, not plotted or interpolated.
gt;gt; gt;gt;
gt;gt; gt;gt; To make your choice, select your chart, go to Tools gt; Options gt; Charts
gt;gt; gt;gt; and
gt;gt; gt;gt; select the Not Plotted option button for empty cells.
gt;gt; gt;gt;
gt;gt; gt;gt; ....Kelly
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Sheila Innesquot; gt; wrote in
gt;gt; gt;gt; message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;I have a spreadsheet with a two columns, one for expected enrolment
gt;gt; gt;gt; gt;numbers
gt;gt; gt;gt; gt; and the first column of actual enrolments. For April we expect 90,
gt;gt; gt;gt; gt; so
gt;gt; gt;gt; gt; have a
gt;gt; gt;gt; gt; blank cell to the right for actual. This is showing a line from the
gt;gt; gt;gt; gt; March
gt;gt; gt;gt; gt; enrolment of 3 down to 0. How do I get the line to stop at 3 until
gt;gt; gt;gt; gt; I
gt;gt; gt;gt; gt; put
gt;gt; gt;gt; gt; a
gt;gt; gt;gt; gt; figure in for April?
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
Jon

No, there are no formulas in these cells.

Sheila

quot;Jon Peltierquot; wrote:

gt; Sheila -
gt;
gt; Do you have formulas in Recruitment!$B$4:$B$9 and Recruitment!$O$4:$P$9?
gt; This is where you need to change quot;quot; to NA(), if it's a line or XY chart.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;Sheila Innesquot; gt; wrote in message
gt; ...
gt; gt; Hi Jon
gt; gt;
gt; gt; I checked the chart and the 'not plotted' option is already selected. The
gt; gt; equation for the chart is =Recruitment!$B$4:$B$9,Recruitment!$O$4:$P$9.
gt; gt; The B selection is the month, the O is the actual and the P is the target.
gt; gt; Any more help much appreciated.
gt; gt;
gt; gt; Regards
gt; gt; Sheila
gt; gt;
gt; gt;
gt; gt; quot;Jon Peltierquot; wrote:
gt; gt;
gt; gt;gt; 1. Select the chart before going to Tools - Options - Charts.
gt; gt;gt; 2. What kind of chart is it?
gt; gt;gt; 3. If it's a line or XY chart, if you have a formula that returns quot;quot;,
gt; gt;gt; understand that this is not a blank cell, it's a cell with a formula, so
gt; gt;gt; Kelly's solution won't change how the cell plots. Change the quot;quot; in the
gt; gt;gt; formula to NA(), which gives you an ugly #N/A in the cell, but gives you
gt; gt;gt; the
gt; gt;gt; Interpolate behavior in the chart.
gt; gt;gt;
gt; gt;gt; - Jon
gt; gt;gt; -------
gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt; gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; gt;gt; PeltierTech.com/
gt; gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; gt;gt; _______
gt; gt;gt;
gt; gt;gt; quot;Sheila Innesquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Thanks Kelly. Problem - the Not Plotted is grayed out, so I can't mark
gt; gt;gt; gt; it.
gt; gt;gt; gt; Any ideas?
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Kelly O'Dayquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; Excel lets you choose how you can plot empty cells.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; As zeros, not plotted or interpolated.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; To make your choice, select your chart, go to Tools gt; Options gt; Charts
gt; gt;gt; gt;gt; and
gt; gt;gt; gt;gt; select the Not Plotted option button for empty cells.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; ....Kelly
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;Sheila Innesquot; gt; wrote in
gt; gt;gt; gt;gt; message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt;I have a spreadsheet with a two columns, one for expected enrolment
gt; gt;gt; gt;gt; gt;numbers
gt; gt;gt; gt;gt; gt; and the first column of actual enrolments. For April we expect 90,
gt; gt;gt; gt;gt; gt; so
gt; gt;gt; gt;gt; gt; have a
gt; gt;gt; gt;gt; gt; blank cell to the right for actual. This is showing a line from the
gt; gt;gt; gt;gt; gt; March
gt; gt;gt; gt;gt; gt; enrolment of 3 down to 0. How do I get the line to stop at 3 until
gt; gt;gt; gt;gt; gt; I
gt; gt;gt; gt;gt; gt; put
gt; gt;gt; gt;gt; gt; a
gt; gt;gt; gt;gt; gt; figure in for April?
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Then make sure the cells are truly blank.

Is it an area chart? An area chart doesn't treat blanks or NA() the same way
that line or XY charts do.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;Sheila Innesquot; gt; wrote in message
...
gt; Jon
gt;
gt; No, there are no formulas in these cells.
gt;
gt; Sheila
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; Sheila -
gt;gt;
gt;gt; Do you have formulas in Recruitment!$B$4:$B$9 and Recruitment!$O$4:$P$9?
gt;gt; This is where you need to change quot;quot; to NA(), if it's a line or XY chart.
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt;gt; PeltierTech.com/
gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt;gt; _______
gt;gt;
gt;gt; quot;Sheila Innesquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi Jon
gt;gt; gt;
gt;gt; gt; I checked the chart and the 'not plotted' option is already selected.
gt;gt; gt; The
gt;gt; gt; equation for the chart is =Recruitment!$B$4:$B$9,Recruitment!$O$4:$P$9.
gt;gt; gt; The B selection is the month, the O is the actual and the P is the
gt;gt; gt; target.
gt;gt; gt; Any more help much appreciated.
gt;gt; gt;
gt;gt; gt; Regards
gt;gt; gt; Sheila
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Jon Peltierquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; 1. Select the chart before going to Tools - Options - Charts.
gt;gt; gt;gt; 2. What kind of chart is it?
gt;gt; gt;gt; 3. If it's a line or XY chart, if you have a formula that returns quot;quot;,
gt;gt; gt;gt; understand that this is not a blank cell, it's a cell with a formula,
gt;gt; gt;gt; so
gt;gt; gt;gt; Kelly's solution won't change how the cell plots. Change the quot;quot; in the
gt;gt; gt;gt; formula to NA(), which gives you an ugly #N/A in the cell, but gives
gt;gt; gt;gt; you
gt;gt; gt;gt; the
gt;gt; gt;gt; Interpolate behavior in the chart.
gt;gt; gt;gt;
gt;gt; gt;gt; - Jon
gt;gt; gt;gt; -------
gt;gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt;gt; gt;gt; PeltierTech.com/
gt;gt; gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt;gt; gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt;gt; gt;gt; _______
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Sheila Innesquot; gt; wrote in
gt;gt; gt;gt; message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Thanks Kelly. Problem - the Not Plotted is grayed out, so I can't
gt;gt; gt;gt; gt; mark
gt;gt; gt;gt; gt; it.
gt;gt; gt;gt; gt; Any ideas?
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; quot;Kelly O'Dayquot; wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; Excel lets you choose how you can plot empty cells.
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; As zeros, not plotted or interpolated.
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; To make your choice, select your chart, go to Tools gt; Options gt;
gt;gt; gt;gt; gt;gt; Charts
gt;gt; gt;gt; gt;gt; and
gt;gt; gt;gt; gt;gt; select the Not Plotted option button for empty cells.
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; ....Kelly
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; quot;Sheila Innesquot; gt; wrote in
gt;gt; gt;gt; gt;gt; message
gt;gt; gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;gt; gt;I have a spreadsheet with a two columns, one for expected
gt;gt; gt;gt; gt;gt; gt;enrolment
gt;gt; gt;gt; gt;gt; gt;numbers
gt;gt; gt;gt; gt;gt; gt; and the first column of actual enrolments. For April we expect
gt;gt; gt;gt; gt;gt; gt; 90,
gt;gt; gt;gt; gt;gt; gt; so
gt;gt; gt;gt; gt;gt; gt; have a
gt;gt; gt;gt; gt;gt; gt; blank cell to the right for actual. This is showing a line from
gt;gt; gt;gt; gt;gt; gt; the
gt;gt; gt;gt; gt;gt; gt; March
gt;gt; gt;gt; gt;gt; gt; enrolment of 3 down to 0. How do I get the line to stop at 3
gt;gt; gt;gt; gt;gt; gt; until
gt;gt; gt;gt; gt;gt; gt; I
gt;gt; gt;gt; gt;gt; gt; put
gt;gt; gt;gt; gt;gt; gt; a
gt;gt; gt;gt; gt;gt; gt; figure in for April?
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;