Adding a control line to excel chart without showing up in the leg
 

How can I add a control line, (such as average, ucl, lcl), to an excel bar or
line chart and not have the control line series show up in the chart legend,
or data table?

Any sugestions would be greatly appreciated.
--
thanks
tweaver

Adding a control line to excel chart without showing up in the leg
 

On Sat, 15 Sep 2007, in microsoft.public.excel.charting,
TWeaver said:

How can I add a control line, (such as average, ucl, lcl), to an excel bar or
line chart and not have the control line series show up in the chart legend,
or data table?

Single-click twice on the legend entry for the control line, and delete
it.

Don't use the data table, instead use the camera tool to insert a
spreadsheet range below the graph, or embed the graph above a
spreadsheet range. It's better than a data table anyway, because the
formatting is much more flexible that way.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Adding a control line to excel chart without showing up in theleg
 

Hi,

For the legend you can delete the entry.
http://www.andypope.info/charts/deletelegendentry.htm

The data table though you have no control over.
Have a look at this though.
http://tushar-mehta.com/excel/newsgr...able/index.htm

Cheers
Andy

TWeaver wrote:
How can I add a control line, (such as average, ucl, lcl), to an excel bar or
line chart and not have the control line series show up in the chart legend,
or data table?

Any sugestions would be greatly appreciated.

Adding a control line to excel chart without showing up in the
 

Thanks for the tip. I was ablke to remove the control line entry within my
charts that have legends.

However, I still have a workbook with several dozen charts that have data
tables. Using the Camera to copy an image of the worksheet data table is not
an option, because I need the data to update dynamically. As I update the
source data, the chart data table needs to update without any intervention on
my part. Otherwise it will be more work than what it is worth.

Embedding these charts into worksheets seems to require quit a bit of finese
in lining up the column. Expecially whne I copy it over to a powerpoint
slide. It seems to loose a bit of the alignment.

I am curently using a cut-n-paste image of a control line and that seems to
do ok, except the line gets a bit out of alignment from time to time when I
update the chart data.
--
thanks
tweaver


"Del Cotter" wrote:

On Sat, 15 Sep 2007, in microsoft.public.excel.charting,
TWeaver said:

How can I add a control line, (such as average, ucl, lcl), to an excel bar or
line chart and not have the control line series show up in the chart legend,
or data table?

Single-click twice on the legend entry for the control line, and delete
it.

Don't use the data table, instead use the camera tool to insert a
spreadsheet range below the graph, or embed the graph above a
spreadsheet range. It's better than a data table anyway, because the
formatting is much more flexible that way.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Adding a control line to excel chart without showing up in the
 

The camera tool pictures are dynamic, but after you have a dozen or so, they
slow way down. Put the table in regular cells adjacent to the chart.

For your control lines, use something like this:

http://peltiertech.com/Excel/Charts/RunChtLines.html
http://peltiertech.com/Excel/Charts/AddLine.html

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


"TWeaver" wrote in message
...
Thanks for the tip. I was ablke to remove the control line entry within
my
charts that have legends.

However, I still have a workbook with several dozen charts that have data
tables. Using the Camera to copy an image of the worksheet data table is
not
an option, because I need the data to update dynamically. As I update the
source data, the chart data table needs to update without any intervention
on
my part. Otherwise it will be more work than what it is worth.

Embedding these charts into worksheets seems to require quit a bit of
finese
in lining up the column. Expecially whne I copy it over to a powerpoint
slide. It seems to loose a bit of the alignment.

I am curently using a cut-n-paste image of a control line and that seems
to
do ok, except the line gets a bit out of alignment from time to time when
I
update the chart data.
--
thanks
tweaver


"Del Cotter" wrote:

On Sat, 15 Sep 2007, in microsoft.public.excel.charting,
TWeaver said:

How can I add a control line, (such as average, ucl, lcl), to an excel
bar or
line chart and not have the control line series show up in the chart
legend,
or data table?

Single-click twice on the legend entry for the control line, and delete
it.

Don't use the data table, instead use the camera tool to insert a
spreadsheet range below the graph, or embed the graph above a
spreadsheet range. It's better than a data table anyway, because the
formatting is much more flexible that way.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.