Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 560
Default 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.
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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.

  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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.

  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Type - Line Column adding a 2nd line [email protected] Charts and Charting in Excel 1 October 24th 06 04:17 PM
Data showing incorrectly on line chart gobonniego Charts and Charting in Excel 1 June 15th 06 07:56 PM
Data showing incorrectly on line chart gobonniego Charts and Charting in Excel 1 June 7th 06 09:27 AM
Combination chart - want only ONE series showing as a line, not 2. sincaa Charts and Charting in Excel 1 January 26th 06 10:28 AM
Chart showing one line for several rows PEA Charts and Charting in Excel 0 August 30th 05 07:48 AM


All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"