That is excellent. You are an excellent resource! I found your web site very
useful.
Finally, can you explain the references in the formula you suggest
"=IF(C$3,C6,NA())" so I can understand and apply to my data a bit more
intuitively as my columns don't line up the same. Is it a simple matter to
copy the buttons to the chart worksheet, while the data remains on another?
-Jim-

"Jon Peltier" wrote:

Jim -

If you set up another range with the smoothed data, and don't hide it like
the other series, it will appear in the chart. Charting one series is
independent of the others. Not charting a series doesn't make the smoothing
calculations not work.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim" wrote in message
...
Thanks Jon, I'm working on your exapmles.
Now that I see your reply, I have to ask another question: I am plotting
the
average of the data points over my raw data (to show a smoothed 'trend'
curve), so will I be able to show this when the data series is hidden?
I'd like to hide the raw data and show the smoothed, to summarize.
Thanks, Jim.

"Jon Peltier" wrote:

You could hide the row/column that contains data for that series. Record
a
macro while doing it manually to get the code.

You could also try one of these techniques:

http://peltiertech.com/Excel/Charts/ChartByControl.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim" wrote in message
...
How do I add a button to hide/show a data series in my log or semi log
chart.