Yes I saw that when testing. I guess the copy process doesn't check invalid
settings and uses defaults instead.
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jon Peltier" wrote in message
...
Want to see something fun? Make a line chart with a missing value in the
middle, set the option to connect points across a gap, then convert to an
unstacked area chart. Where the area chart would have shown a gap with
vertical sides, now the area is filled up to the top of the chart between
vertical sides. If you copy the chart, the copy treats the gap as a zero,
and when you change back to gap, you get the gap to the bottom, not the
block to the top.
Only the unstacked area charts give you a gap with vertical sides (and as
I mentioned, the copy of one has its option reset to zero). The stacked
ones can only treat the gap as zero.
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______
"Andy Pope" wrote in message
...
Hi,
The NA() trick does/did not work with area charts.
xl2003: the gap in data results in a zero value. The Empty cells options
of Gap/Interpolate are the same, zero.
xl2007: the gap plotted as zero is as expected. Plotted as gap produces
shear drops between gaps.
The only way to fill the gap is to use another series to plot the missing
values. You will need formula to calculate the interpolated values.
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"BABs" wrote in message
...
Bernard,
That worked for bridging the gaps in the line plot, but not the area
chart.
The area chart has the "connect" grayed out. Also, if I enter =na(), it
treats them as 0's and doesn't interpolate.
Any suggestions?
"Bernard Liengme" wrote:
Click the chart to activate it
In the Design tab of Chart Tools, click Select Data
A dialog box opens, look at lower left corner for "Hidden and Empty
Cells"
button and click it
You get three options: gaps, zero and connect.
Alternative (works in all version of Excel); in the empty cell type
=NA().
It will display as #N/A and will be ignored by the chart engine
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"BABs" wrote in message
...
XL 2007 doesn't have the TOOLS-Options-Interpolate menu and choices.
This goes for a line chart as well.
Thx